Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I lock the top row of column headings so they remain in view as I
scroll down the columns? Thanks! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- David Biddulph "wadp1" wrote in message ... How do I lock the top row of column headings so they remain in view as I scroll down the columns? Thanks! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select A2, WindowFreeze Pane
-- Kind regards, Niek Otten Microsoft MVP - Excel "wadp1" wrote in message ... | How do I lock the top row of column headings so they remain in view as I | scroll down the columns? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using an Index by Column Headings instead of Column Numbers | New Users to Excel | |||
Lookup function/sum function | Excel Discussion (Misc queries) | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions |