How to Freeze Multiple Rows and Columns in Excel Using Freeze Panes (Lock Rows and Columns in Excel)

In this video, I will show you How to Freeze Multiple Rows and Columns in Excel using the Freeze Panes option along with how to freeze the top row and first column in excel.

Steps on how to freeze multiple rows and columns in Excel using freeze panes at the same time?
Step 1: Click on a cell
Step 2: Click on View Tab
Step 3: Click on “Freeze Pane”

Freeze the multiple rows and columns so that row headings stay visible as you scroll down and required columns stay visible as you scroll to the right side.

Freeze Panes in Excel allows you to lock or fix rows and columns so that they don't disappear whenever you scroll in your worksheet.

Learn how to Freeze and Unfreeze multiple rows and multiple columns in Excel using the Freeze Panes in this Video.

#excel #exceltips #freezepanes

[mohdtufail]

Thank you a lot it helps me to do my work more easily thank you 😊

[vipinyadavseo]

Very Imformative video- Cleared all doubt about Freeze columns and rows in Excel.

[g-manarjun]

Thanks you so much ma'am for your guidance this video very helpful for me 👍👌🤟

[SumanSharma-nfdd]

Good content - I found this video very informative

[elakkiya.r]

Thank u so much for Ur knowledge sharing

[Girish]

It was very helpful.. keep up the good work.

[atma_anveshan]

Sir, excel ki protected file watsup se bhejne pe unprotect ho jati hai, protect bnaye rkhne ki trick bataiye pls