Freezing Panes and View Choices

Freezing Panes and View Options
February 23, 2021 0 Comments

Lesson 17: Freezing Panes and View Choices

/en/excel2013/capabilities/content material/

Introduction

Everytime you’re working with a number of information, it may be tough to evaluate info in your workbook. Fortuitously, Excel contains a number of instruments that make it simpler to view content material from completely different elements of your workbook on the similar time, akin to the flexibility to freeze panes and cut up your worksheet

Non-compulsory: Obtain our apply workbook.

To freeze rows:

It’s possible you’ll wish to see sure rows or columns on a regular basis in your worksheet, particularly header cells. By freezing rows or columns in place, you’ll scroll by means of your content material whereas persevering with to view the frozen cells.

  1. Choose the row beneath the row(s) you wish to freeze. In our instance, we wish to freeze rows 1 and 2, so we’ll choose row 3.
    Screenshot of Excel 2013Choosing row 3
  2. Click on the View tab on the Ribbon.
  3. Choose the Freeze Panes command, then select Freeze Panes from the drop-down menu.
    Screenshot of Excel 2013Clicking Freeze Panes
  4. The rows will probably be frozen in place, as indicated by the grey line. You’ll be able to scroll down the worksheet whereas persevering with to view the frozen rows on the prime. In our instance, we have scrolled all the way down to row 18.
    Screenshot of Excel 2013The frozen rows

To freeze columns:

  1. Choose the column to the suitable of the column(s) you wish to freeze. In our instance, we wish to freeze column A, so we’ll choose column B.
    Screenshot of Excel 2013Choosing column B
  2. Click on the View tab on the Ribbon.
  3. Choose the Freeze Panes command, then select Freeze Panes from the drop-down menu.
    Screenshot of Excel 2013Clicking Freeze Panes
  4. The column will probably be frozen in place, as indicated by the grey line. You’ll be able to scroll throughout the worksheet whereas persevering with to view the frozen column on the left. In our instance, we have scrolled throughout to column E.
    Screenshot of Excel 2013The frozen column

To unfreeze rows or columns, click on the Freeze Panes command, then choose Unfreeze Panes from the drop-down menu.

Screenshot of Excel 2013Unfreezing a row

In case you solely have to freeze the prime row (row 1) or first column (column A) within the worksheet, you may merely choose Freeze High Row or Freeze First Column from the drop-down menu.

Screenshot of Excel 2013Freezing solely the highest row of a workbook

Different view choices

In case your workbook comprises a number of content material, it will possibly typically be tough to match completely different sections. Excel contains further choices to make your workbooks simpler to view and evaluate. For instance, you may select to open a new window on your workbook or cut up a worksheet into separate panes.

To open a brand new window for the present workbook:

Excel permits you to open a number of home windows for a single workbook on the similar time. In our instance, we’ll use this function to match two completely different worksheets from the identical workbook.

  1. Click on the View tab on the Ribbon, then choose the New Window command.
    Screenshot of Excel 2013Clicking the New Window command
  2. A new window for the workbook will seem.
    Screenshot of Excel 2013The identical workbook open in two separate home windows
  3. Now you can evaluate completely different worksheets from the identical workbook throughout home windows. In our instance, we’ll choose the 2013 Gross sales Detailed View worksheet to match the 2012 and 2013 gross sales.
    Screenshot of Excel 2013Choosing a worksheet in a brand new window

You probably have a number of home windows open on the similar time, you need to use the Organize All command to rearrange them rapidly.

Screenshot of Excel 2013Clicking Organize All

To separate a worksheet:

Typically you could wish to evaluate completely different sections of the identical workbook with out creating a brand new window. The Cut up command permits you to divide the worksheet into a number of panes that scroll individually.

  1. Choose the cell the place you wish to cut up the worksheet. In our instance, we’ll choose cell C7.
    Screenshot of Excel 2013Choosing cell C7
  2. Click on the View tab on the Ribbon, then choose the Cut up command.
    Screenshot of Excel 2013Clicking the Cut up command
  3. The workbook will probably be cut up into completely different panes. You’ll be able to scroll by means of every pane individually utilizing the scroll bars, permitting you to match completely different sections of the workbook.
    Screenshot of Excel 2013The cut up worksheet

After making a cut up, you may click on and drag the vertical and horizontal dividers to vary the scale of every part.

To take away the cut up, click on the Cut up command once more.

Problem!

  1. Open an present Excel workbook. If you would like, you need to use our apply workbook.
  2. Strive freezing a row or column in place. In case you are utilizing the instance, freeze the prime two rows (rows 1 and a pair of).
  3. Strive opening a new window on your workbook.
  4. Use the Cut up command to separate your worksheet into a number of panes.

/en/excel2013/sorting-data/content material/

Leave a Reply

Your email address will not be published. Required fields are marked *