How to Freeze Multiple Rows and Columns in Excel

Опубликовано: 09 Июль 2026
на канале: Excel Secrets

41,659

554

This video tutorial covers how to freeze multiple rows and columns in excel (Freeze panes). This applies when one is working on a report with huge data whereby the headers or columns with key information may be hidden as you scroll through the document/worksheet. Therefore,freezing panes ensures a certain area of the worksheet remains visible for ease of reference as you scroll through.
NB: You can only freeze rows at the top of a worksheet or column on the left side of a worksheet. Rows and columns at the centre of a worksheet cannot be frozen.

This video tutorial covers:
1. How to freeze multiple rows
2. How to freeze multiple columns
3. How to freeze multiple rows and columns simultaneously(at the same time)
4. How to unfreeze rows and columns. NB: The steps of unfreezing rows and columns are the same.

At excel secrets, our aim is to ensure you get the best from our tutorials and to make your work as easier as you learn excel tricks from our tutorials.
Make sure you SUBSCRIBE to our channel, like, leave a comment and hit the notification bell to be notified every time we upload a new video.Cheers!

Freezing multiple rows and columns in excel
Freeze panes in excel
Lock rows and columns in excel
How to freeze panes in excel
How to freeze columns in excel
How to freeze rows in excel
How to freeze rows and columns in excel
How to freeze columns and rows in excel
How to freeze more than one row in excel
How to freeze more than one column in excel
How to freeze and unfreeze rows and columns in excel
How to freeze top row and top column in excel
How to keep top row and column visible
Shortcut keys for freeze panes
How to keep the title row from scrolling in excel
Excel-Freezing rows and columns
How to keep selected rows visible
How to keep selected columns visible
How to keep selected rows and columns visible
How to freeze selected rows
How to freeze selected columns
How to freeze selected rows and columns

#excel #exceltutorial #exceltips #excelsecrets #excelseries #howto #rows #column #columns #row #hide #unhide #exceltutorials #exceltutorial2022 #freeze #freezing #2023