tech-tip

To view the column headings on an Excel spreadsheet no matter how far you scroll down, follow these steps.

  1. Select cell A2, or the first cell of the row below the rows you want to freeze.
  2. From the Excel toolbar select Window > Freeze Panes.

A line will appear between rows 1 and 2 and the column headings will remain visible no matter how far down you scroll. To undo this step, select Window > Unfreeze Panes.

Read: Are you getting the most out of your client relationship software?

You can also freeze some of the columns so their values are visible no matter how far you scroll to the right. Suppose column A is Last Name and column B is First Name.

To be able to see these values no matter how far you scroll to the right, follow these steps.

  1. Select cell C1, or the first cell to the right of the columns you want to freeze.
  2. From the toolbar select Window > Freeze Panes.

You will be able to see the last name and first name values no matter how far you scroll to the right.

Read: Save money, dazzle clients with Excel

To freeze the column headings and some columns at the same time, select the cell below the header row and to the right of the columns you want to freeze before selecting Window > Freeze Panes. In the example above, this would be cell C2.

Now you can read the column headings now matter how far down you scroll, and you can see the last name and first name values no matter how far right you scroll.

David Dagley, CFP®, is a software developer and Adobe javascript expert, with 15 years of financial planning experience. He is the owner and president of Forms Doctor Inc., a company specializing in workflow automation solutions and financial planning calculators for investment dealers, financial advisors, and investment firms.
Originally published on Advisor.ca

Add a comment

You must be logged in to comment.

Register on Advisor.ca