Excel Freeze Panes

%3CLINGO-SUB%20id%3D%22lingo-sub-2259034%22%20slang%3D%22en-US%22%3EExcel%20Freeze%20Panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259034%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20is%20MS%20Excel%20Freeze%20Panes%20so%20broken%3F%26nbsp%3B%20I'%20trying%20to%20freeze%20lines%201%20-%204%20and%20columns%20A%20-%20N%20on%20a%20spreadsheet%20I%20have%20created.%26nbsp%3B%20I%20found%20out%20that%20I%20need%20to%20go%20to%20the%20furthest%20cell%20and%20column%20to%20the%20right%20of%20the%20workspace%20and%20I%20successfully%20froze%20what%20I%20needed.%26nbsp%3B%20However%2C%20when%20I%20went%20to%20enter%20data%20into%20the%20cells%2C%20I%20could%20no%20longer%20scroll%20past%20column%20L%20and%20access%20the%20other%20cells.%26nbsp%3B%20What%20gives%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20remember%20highlighting%20what%20you%20wanted%20frozen%20and%20then%20clicking%20Freeze%20Panes.%26nbsp%3B%20It%20used%20to%20work%20like%20a%20charm.%26nbsp%3B%20Seem%20like%20the%20software%20has%20regressed...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2259034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Why is MS Excel Freeze Panes so broken?  I' trying to freeze lines 1 - 4 and columns A - N on a spreadsheet I have created.  I found out that I need to go to the furthest cell and column to the right of the workspace and I successfully froze what I needed.  However, when I went to enter data into the cells, I could no longer scroll past column L and access the other cells.  What gives?

 

I remember highlighting what you wanted frozen and then clicking Freeze Panes.  It used to work like a charm.  Seem like the software has regressed...

1 Reply

@Paul_Walker1 

I have used Excel since its earliest versions, and it has always been necessary to select the cell below the last row that you want to freeze, and to the right of the last column you want to freeze.

So if you want to freeze rows 1 to 4 and columns A to N, you have to select cell O5 and then click Freeze Panes > Freeze Panes.

The window will have to be wide enough to display columns A to N plus at least one column more.