Freeze Panes is an excellent tool in Excel 2013 for viewing different parts of the same worksheet that normally cannot be seen together. Generally, this tool is used to freeze headings in top rows and first columns so that it is visible at all times while scrolling the worksheet.
This is particularly useful in cases where we have large spreadsheet with too many rows and columns that do not fit on the screen.
Let's understand this on the basis of an example. The spreadsheet contains financials of a company with multiple years and several line times. We want to view heading and line items at all times. To create and freeze these panes, follow these steps:
Let's understand this on the basis of an example. The spreadsheet contains financials of a company with multiple years and several line times. We want to view heading and line items at all times. To create and freeze these panes, follow these steps:
1. Position the cell cursor in cell B2 (intersection cell)
Excel will freeze the rows above this cell and columns to the left of this cell.
2. "VIEW" tab in ribbon>>>Freeze Panes dropdown>>>Freeze Panes [Shortcut: Alt+WFF]
Excel will automatically show black line on the top row and left column of the selected cell indicating frozen rows and columns.
FREEZE TOP ROW or FIRST COLUMN:
Excel also provides customized option to freeze only top row or first column of the worksheet, regardless of where the cell cursor is located. Follow the below steps:
"VIEW" tab >>> Freeze Panes dropdown >>> Freeze Top Row [Shortcut: Alt+WFR]
"VIEW" tab >>> Freeze Panes dropdown >>> Freeze First Column [Shortcut: Alt+WFC]
UNFREEZE PANES:
To unfreeze any of the panes, there is one stop solution. Go to:
Go to: "VIEW" tab >>> Freeze Panes dropdown >>> Unfreeze Panes [Shortcut: Alt+WFF]
This will automatically remove the black lines from the worksheet, indicating that Excel has unfrozen them.
IMPORTANT NOTE:
- There is no default option to freeze multiple rows without freezing any columns. To do this, go to Column A and place the cell cursor below the rows you want to freeze and then go to freeze panes (Alt+WFF).
- Similarly, there is no default option to freeze multiple columns without freezing any rows. To do this, go to Row 1 and place the cell cursor to the right of columns that needs to be freezed and then click on freeze panes (Alt+WFF).
No comments:
Post a Comment