How to See Headings and Row Labels as You Scroll Around a Report

August 31, 2021 - by Bill Jelen

How to See Headings and Row Labels as You Scroll Around a Report

Problem: I have a wide spreadsheet. There are headings at the top of the spreadsheet, and there are several columns of labels at the left side of the spreadsheet. I also have monthly sales figures that extend far to the right. I need to be able to scroll through the sales figures while always seeing both the headings at the top and the labels at the left of the spreadsheet.

This is a different report. Three rows of titles. Row 4 is blank. Row 5 has headings. The columns A:F contain labels and then G through R contain Jan, Feb, Mar. This time, you want to keep the labels and headings row in view. The cell pointer is currently on the first number for January, ready to invoke Freeze Panes, which will freeze everything to the left and above the active cell.
Figure 64. See columns A:F as you scroll right.

Strategy: Use the Freeze Panes command on the View tab. You must place the cell pointer in the correct location before using the command.

In the spreadsheet shown above, you might want A1:F5 visible all the time. Then, you could scroll through the monthly figures and always be able to see the customer information in the left columns and the month name information in row 5. Here’s how you make it happen:

  • 1. Select cell G6. This is the first non-frozen cell.

  • 2. Select View, Freeze Panes, Freeze Panes. You will see a solid line between columns F and G and between rows 5 and 6.

Results: As you scroll, you can always see the headings.

As you scroll to the right, you keep seeing columns A through F while October and November scroll in to view.
Figure 65. Scroll out to October and you can still see A:F.

Alternate Strategy: Some people prefer to use Split instead of Freeze Panes. I am not a fan of Split since it is too easy to scroll from one quadrant to another. However, several viewers provided reasons why they prefer Split. Search YouTube for “Learn Excel 1101” for a demo on using split.

Note that the Split handles were removed after Excel 2010.

This article is an excerpt from Power Excel With MrExcel

Title photo by Samantha Fortney on Unsplash

Bill Jelen is the author / co-author of:
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.