| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get my column titles to print at the top of 2nd page?
I want to repeat Row 3, Columns A-G at the top of each page when it prints.
How is that done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get my column titles to print at the top of 2nd page?
In File | Page Setup select the Sheet tab and you will see a box Rows
to Repeat at Top - just enter your row(s) here. Ensure that you exclude them from the print range, otherwise they will appear twice on the first page. Hope this helps. Pete Vikki wrote: I want to repeat Row 3, Columns A-G at the top of each page when it prints. How is that done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get my column titles to print at the top of 2nd page?
File - Page Setup - Sheet - Rows to Repeat at Top
-- HTH... Jim Thomlinson "Vikki" wrote: I want to repeat Row 3, Columns A-G at the top of each page when it prints. How is that done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print 'Column A' on every page | Excel Worksheet Functions | |||
| Column Titles on top of every printed page | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
| How to get a long column of numbers to wrap and print on 1 page? | Excel Discussion (Misc queries) | |||
Linear Mode
