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.
To get freeze panes in excel execute the below steps:
1. Click on View Tab.
2. Click on Window Group.
3. There you will get Freeze Panes Option.
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
Let us take some examples of freeze panes in excel:
To freeze the top row in Excel, execute the below steps.
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.
To freeze the first column in Excel, follow the below steps.
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.
To freeze cells in Excel, follow the below steps.
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.
To Unfreeze all rows and columns, follow the below steps.
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.
Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.
1 Comments
Hello World! https://apel.top/go/gu4winrshe5dgoju?hs=eeaddfe2869e18e9d76b3f27bdd0569a& says: rvrnvd |
To Learn:
Tutorials in a simple Way.
Excel with downloadable samples.
HTML with sample website code.
PowerPoint presentations.
MS Word for offical use.