Keep Spreadsheet Headings in View

BY STANLEY ZAROWIN

Q. When I’m scrolling deep into a large Excel worksheet, I often forget the title of a column or row at the beginning of the worksheet because I can’t see the column heading—it’s buried either on the top or the left side of the screen. Is there a way to see the column or row headings no matter where I am in the worksheet?

A. Excel’s Freeze Panes tool allows you to freeze rows and columns on the screen. If you freeze the headings, no matter how far you scroll down or to the right, those headings remain visible.

To freeze a row, choose the row number or the cell that’s immediately beneath the last row you want frozen. Then go to the toolbar and click on Window, Freeze Panes. Excel inserts a thin line to show you where the frozen pane starts. To freeze a column, pick the column letter or the cell in the row immediately to the right of the last column you want frozen. You can engage the Freeze Panes tool anywhere in the worksheet.

To freeze horizontal and vertical headings at the same time, select the cell that’s in the upper-left corner of the range you want to remain scrollable and then invoke the Freeze Panes feature. To restore the workbook to its standard view, click on Window, Unfreeze Panes.

Note how row 1 and column A continue to show no matter how far you scroll into the worksheet.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.