Saturday, May 1, 2021

How to Freeze and UnFreeze Multiple Excel Panes

 Excel Version Used: 16.48

Freeze Multiple Rows

Step 1: Under the View ribbon check for option if UnFreeze Panes exists if any rows already frozen.




Step 2: Place the Cursor in the row where all the above row need to be frozen and click the "Freeze Panes" button now to freeze all the rows above the cursor.



Freeze Multiple row and Column

Step 1: Under the View ribbon check for option if UnFreeze Panes exists if any rows already frozen.


Step 2: Place the Cursor in the row where all the above row and left column need to be frozen and click the "Freeze Panes" button now to freeze all the rows above the cursor and left columns of the cursor.