Microsoft Excel

Freeze First Column

Think, you have a spreadsheet with headings at the First left column, as shown in figure below. You want to be able to scroll through the data and always see the headings.

Large Worksheet Column Wise Headings

You can use the Freeze Panes command on the View tab, in the Window group and then click on Freeze First Column.

Freeze First Column

A solid vertical line will be drawn after first column. As you scroll right you will always be able to see the heading column, as shown in figure below.

Vertical line for First Column Freeze

by BrainBellupdated
Advertisement: