| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Print Column Headings
I am trying to print my column headings (the contents of row 1) on each page,
but Excel is not having it. I have the pane frozen, so that row 1 is always visible on the screen when I scroll. In the past, this has also given me the column headings on printouts, but not this time. "Help" tells me to use the "Rows to repeat..." setting in "Sheet" under print setup. However, the option is greyed out. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Print Column Headings
Don't go through the print preview dialog.
Go through File|page setup|sheet tab. Mark D. Brown, MSW wrote: I am trying to print my column headings (the contents of row 1) on each page, but Excel is not having it. I have the pane frozen, so that row 1 is always visible on the screen when I scroll. In the past, this has also given me the column headings on printouts, but not this time. "Help" tells me to use the "Rows to repeat..." setting in "Sheet" under print setup. However, the option is greyed out. What am I doing wrong? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Print Column Headings
That did the trick. Thanks!
"Dave Peterson" wrote: Don't go through the print preview dialog. Go through File|page setup|sheet tab. Mark D. Brown, MSW wrote: I am trying to print my column headings (the contents of row 1) on each page, but Excel is not having it. I have the pane frozen, so that row 1 is always visible on the screen when I scroll. In the past, this has also given me the column headings on printouts, but not this time. "Help" tells me to use the "Rows to repeat..." setting in "Sheet" under print setup. However, the option is greyed out. What am I doing wrong? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get a long column of numbers to wrap and print on 1 page? | Excel Discussion (Misc queries) | |||
| How do I change column headings from A,B,C to actual words? | Excel Worksheet Functions | |||
| How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
| Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
