In my book, I stick to solutions that work. But when I teach an Excel course, I take time to point out things that can go wrong. 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 to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-1.xlsx” to view the problem. 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 to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-2.xlsx” to view this situation. Both of these problems are a result of someone incorrectly applying the Freeze Panes feature. 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. In the second case, this can happen if someone applies the Freeze Panes feature while the data is filtered. To fix the problem in the first case, Unfreeze the Panes, click some cell other than Cell A1, and reapply the Freeze Panes feature. To fix the problem in the second case, Unfreeze the Panes, make sure the data is not filtered, and reapply the Freeze Panes feature. For more information on the Freeze Panes feature, please see Chapter 2 of 'Simply learning Excel 2007.'

FYI, I was having a problem with freeze panes where I’d select the rows I want frozen, but then after invoking the “Freeze Panes” function I found that more rows were included in this than I’d selected. Outlook deleted items folder missing. I had highlighted the first 3 rows, but the first 10 rows were frozen. By trial and error, I discovered that if I simply click in a cell right below where I want the freeze pane to end, THAT works. So in this case I click on cell A4, and the top 3 rows are now included in the freeze pane. I am baffled beyond belief why it functions this way, in Excel 2013.

I have a worksheet with many rows and columns of data. I have frozen the first row and column by making cell B2 active and then freezing panes. This works as I want it to. I can even save and close the file, and the panes are still frozen when I reopen the file. However, if I open a new window for this file (View/Window/New Window), the new window does NOT have frozen panes. Dose grammartly support office for mac.

Use the Freeze Panes menu to quickly unfreeze all the panes in Excel. The data in the frames will remain, but the row(s) and/or column(s) that were frozen will return to their original positions. The data in the frames will remain, but the row(s) and/or column(s) that were frozen will return to their original positions. To unfreeze panes, just do the following: go to the View tab, Window group, and click Freeze panes > Unfreeze Panes. Excel Freeze Panes tips. As you have just seen, freezing panes in Excel is one of the easiest tasks to perform. However, as is often the case with Microsoft, there is much more beneath the hood.

As I have frozen panes on many tabs in this spreadsheet I have to be VERY careful about which file I close first. If I close the “original window” first, when I close the “new window” it saves all the un-frozen worksheets. Is there a way to get the new window to retain the frozen panes settings? The problem: Row 10 is now the top of my sheet on one of my sheets in one workbook. I have never used filters prior to encountering your website while trying to find a solution to my problem. I have used every combination of freeze this unfreeze this (and That) I could think of.