|||||

Solution for Microsoft Excel Freeze Panes Not Working as Expected

Freeze panes is a good feature in ms office for freezing (keep in same position even during scrawling away with scroll bar) certain top rows or left most columns. But most of the time it don't work as expected when multiple rows/columns or multiple of both are involved

We give below how to solve this issue with detailed images

1. Freezing Top row
As shown in the image View Tab=> Freeze Pane Tab => Freeze Top Row
ms office freezing first row using freeze panes

2. Freezing Left Column

As shown in the image View Tab=> Freeze Pane Tab => Freeze First Column

ms office freezingfirst column using freeze panes

3. Freezing Top Few rows and Left most some Rows Together

Select the cell above which rows and left of its columns should freeze, Keep pressing shift button and press Freeze panes button
As shown in the image 'View Tab' => 'Freeze Pane Tab' => 'Freeze Panes'

ms office freezing multiple rows or-and columns using freeze panes

To reset Freezepanes press un freeze button from 'View Tab' => 'Freeze Pane Tab' => 'UnFreeze Panes'

Please note if you are in Page Layout View, you can't see Freeze panes menu. Switch back to Normal or Page Break Preview viewing mode to bring back your Freeze Panes function