|Connect us with


Freeze Panes in Excel

Where is 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. which 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 in Excel:

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 in Excel?

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 in Excel

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:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.