![]() In the second case, this can happen if someone applies the Freeze Panes feature while the data is filtered. In the first case, the crosshairs in the middle are a result of someone applying the Freeze Panes feature while Cell A1 is the active cell. Or, have you ever opened a spreadsheet and tried to move down the spreadsheet using either the scroll bar or keyboard down arrow but nothing seemed to happen? Please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-2.xlsx” to view this situation.īoth of these problems are a result of someone incorrectly applying the Freeze Panes feature. For example, has your screen ever had crosshairs in the middle of the worksheet? If you’re not sure what I’m talking about, please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-1.xlsx” to view the problem. But when I teach an Excel course, I take time to point out things that can go wrong. In my book, I stick to solutions that work.
0 Comments
Leave a Reply. |