view column headings

[Guest]

How do I lock the top row of column headings so they remain in view as I
scroll down the columns? Thanks!

 

[David Biddulph]

If you don't really mean the column headings (A, B, C, ...) but whatever you
have in row 1 of your spreadsheet, then you want "freeze panes", so click on
row 2, then Window/ Freeze Panes. If, as well as freezing row 1, you also
wanted to freeze columns A and B (for example), then click in cell C2, and
Window/ Freeze Panes. It will freeze everything above and to the left of the
active cell.

 

[Niek Otten]

Select A2, Window>Freeze Pane

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I lock the top row of column headings so they remain in view as I
| scroll down the columns? Thanks!