| Be My Friend

Freeze Panes in Excel

Freeze Panes | Shortcut | Freeze Top Row | Freeze First Column | Freeze Cells | Unfreeze Panes

Freeze panes in Excel are used to lock the specific cells, rows, or columns.

If you have more data in the workbook, freeze panes help to lock the selected row or column.

It means it keeps row or column visible even after scrolling the data also.

Where is Freeze Panes in Excel

To get freeze panes in excel execute the below steps:

Freeze Panes in Excel

1. Click on View Tab.

2. Click on Window Group.

3. There you will get Freeze Panes Option.

Shortcut to Freeze Panes

To freeze row and column: ALT + W + F + F

To freeze the top row: ALT + W + F + R

To freeze the top column: ALT + W + F + C

How to Freeze Panes

Let us take some examples of freeze panes in excel:

Freeze Top Row

To freeze the top row in Excel, execute the below steps.

Freeze Top Row

1. Put the cursor on the Cell.

2. Go to View Tab and click on Freeze Panes.

3. And click on Freeze Top Row.

Now the result is, Excel adds a dark grey line for the top row and it indicates the top row is frozen.now the first row is visible even after scrolling the data Horizontally.

Freeze First Column

To freeze the first column in Excel, follow the below steps.

Freeze First Column

1. Put the cursor on the Cell.

2. Go to View Tab and click on Freeze First Column.

Now, Excel adds a dark grey line for the first column and it is easily indicated that the first column is frozen.

Now the first column is visible even after scrolling the data vertically.

Freeze Cells

To freeze cells in Excel, follow the below steps.

Click Freeze Panes in Excel

1. Select the cell which you want to freeze.

2. Go to View Tab and click on Freeze Panes.

Now Excel adds a dark grey line on the selected cell and it indicates the selected cell is frozen.

Now the row is visible even after scrolling the data horizontally and also column is visible after scrolling vertically.

Unfreeze Panes

To Unfreeze all rows and columns, follow the below steps.

Unfreeze Panes

1. Go to View Tab and click on Unfreeze Panes.

Now Excel removes the dark grey line and if you scroll the sheet both horizontally and vertically no row or column is locked.

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

1 Comments


Hello World! https://apel.top/go/gu4winrshe5dgoju?hs=eeaddfe2869e18e9d76b3f27bdd0569a& says:
Date: Apr 04 2023, 06:08 am

rvrnvd



Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials