MS EXCEL TUTORIAL: HOW TO FREEZE MULTIPLE ROWS AND COLUMNS

When you are working on a large set of data, and you want to retain the top row header, or the left column header when you scroll down or to the right, freeze panes function is the answer.

You can keep an area of a worksheet visible while you scroll to another area by using the Freeze Panes Excel function under the View tab. With this, you can lock specific rows and columns in place. Just go to the cell below the rows and to the right of the columns you want to keep visible when you scroll and click Freeze Panes.

This video also includes a keyboard shortcut for you to be able to do it swiftly.

Title: How to Freeze Multiple Rows and Columns

#freezepanes #freezemultiplerows #freezemultiplecolumns #keyboardshortcut #exceltip