Lesson 17: Freezing Panes and View Options Show /en/excel2013/functions/content/ IntroductionWhenever you're working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, such as the ability to freeze panes and split your worksheet Optional: Download our practice workbook. To freeze rows:You may want to see certain rows or columns all the time in your worksheet, especially header cells. By freezing rows or columns in place, you'll be able to scroll through your content while continuing to view the frozen cells.
To freeze columns:
To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu. Unfreezing a rowIf you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu. Freezing only the top row of a workbookOther view optionsIf your workbook contains a lot of content, it can sometimes be difficult to compare different sections. Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to open a new window for your workbook or split a worksheet into separate panes. To open a new window for the current workbook:Excel allows you to open multiple windows for a single workbook at the same time. In our example, we'll use this feature to compare two different worksheets from the same workbook.
If you have several windows open at the same time, you can use the Arrange All command to rearrange them quickly. Clicking Arrange AllTo split a worksheet:Sometimes you may want to compare different sections of the same workbook without creating a new window. The Split command allows you to divide the worksheet into multiple panes that scroll separately.
After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. To remove the split, click the Split command again. Challenge!
/en/excel2013/sorting-data/content/ Can you freeze top and side panes in Excel at the same time?To freeze horizontal and vertical headings simultaneously:
Select the cell in the upper-left corner of the range you want to remain scrollable. Select View tab, Windows Group, click Freeze Panes from the menu bar. Excel inserts two lines to indicate where the frozen panes begin.
How do I freeze more than 2 columns?Freeze or unfreeze rows or columns. On your computer, open a spreadsheet in Google Sheets.. Select a row or column you want to freeze or unfreeze.. At the top, click View. Freeze.. Select how many rows or columns to freeze.. How do I freeze multiple columns in Excel 2021?To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. Say you want to freeze the top four rows and leftmost three columns. You'd select cell D5, and then on the View tab, click Freeze Panes.
Can you freeze multiple non consecutive rows in Excel?Sorry, no, that isn't possible.
|