Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For printing:
File|page setup|sheet tab|rows to repeat at top For viewing: Select A1 (just to make sure it's visible) select a cell (say B2) window|freeze Panes Everything to the left of that selected cell (b2 in my sample) will be frozen. Everything above that cell will be frozen. Crazy4Dogz wrote: When I name the columns there's a way to make it a "header row" so it's displayed on each page, but I can't remember how. Help? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
File -- Page Setup -- Sheet tab
You should see a field called "Rows to repeat at top" Fill in, or select, your rows here. HTH, Elkar "Crazy4Dogz" wrote: When I name the columns there's a way to make it a "header row" so it's displayed on each page, but I can't remember how. Help? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I name the columns there's a way to make it a "header row" so it's
displayed on each page, but I can't remember how. Help? One way: File Page setup Sheet Rows to repeat at top |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
Excel: can I refer to cell reference in page setup header | Excel Worksheet Functions | |||
how to get a cell on a page to equal the bottom most cell on dif | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions |