Menu
![](/uploads/1/2/5/8/125849345/966111568.jpg)
![Excel Freeze Panes Problems Excel Freeze Panes Problems](/uploads/1/2/5/8/125849345/732611259.jpg)
Freezing panes - Freezing panes ensures that certain rows and columns remain visible at all times - Where the pane freezes depends on the selected cell ALT + W, F, F: Freeze / unfreeze panes to the left and above selected cell. Split boxes - If you want to view two parts of the dataset at the same time, split boxes work well. Sep 5, 2012 - Next, go to the View tab, click on Freeze Panes, and then make a selection from the submenu, such as Freeze Panes. Figure 1: An example of freezing panes on a worksheet. Figure 2: Thin black lines indicate frozen rows and/or columns. Figure 3: Add Freeze Sheet Panes to your Quick Access Toolbar.
September 18th 07, 01:13 PMposted to microsoft.public.excel.misc | ||
| ||
Freeze panes problems in shared workbook The only time I've seen this is when the freeze panes was put on after the data was filtered. I'd show all the data, then reapply the window|Freeze panes in the correct location to see if that helps. Sandra wrote: I have a shared workbook with autofilter and frozen panes and the 'freeze' moves around when the filter is used by users (it seems to move with the filters). Although protecting the windows of the workbook solves the problem, the format of the protected workbook is really not user friendly. Kind of a small minimized window that you can't maximize and move around. Because the settings of the users as well as the size of their monitor are all different, sometimes it's impossible to see the tabs and there is no horizontal scrolling bar. Basically solving one problem causes another. Is there a way to solve one without causing the other? Thanks Sandra -- Dave Peterson |
![](/uploads/1/2/5/8/125849345/966111568.jpg)