Who knows how to make a spreadsheet???

[doanster]

Hey, in Excel, if I have a massive spreadsheet that continues on for many pages, how do I keep the same column headings / title bar on each new page??

 

[KLin]

click on cell A2, click window, click freeze panes.

 

[Baked]

Copy and Paste.

 

[dullard]

Originally posted by: KLin
click on cell A2, click window, click freeze panes.

Also useful: try cell B1 or cell B2.

 

[lozina]

You mean so when you scroll down the list the data moves but some column headers ramain static at the top?

If so, open up your spreadsheet, scroll to the top and look at the vertical scrollbar for your spreadsheet. See that tiny little bar right above the up arrow icon at the top? click and drag that down to expand a window which will stay put even as you scroll. Expand it just enough to show your column headers

 

[GuitarDaddy]

Or if you just want the headings to appear in each page on print.

file/pagesetup/sheet/rows to repeat at top exp(a1..a5)