| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS - Print - Headers
If I have a long spread sheet and I want to print it and see the top three
rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP -- Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS - Print - Headers
File--Page Setup, then click the Sheet tab, and in the field Rows to repeat
at top select the relevant rows. Note that you can't access this via print preview. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave" wrote: If I have a long spread sheet and I want to print it and see the top three rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP -- Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS - Print - Headers
FilePage SetupSheetRows to repeat at top.
Enter $1:$3 or just point to those three rows. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote: If I have a long spread sheet and I want to print it and see the top three rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS - Print - Headers
Dave, Gord,
Thanks, but now when I print I also see the A B C D etc... across the top. I don't want that. -- Dave "Gord Dibben" wrote: FilePage SetupSheetRows to repeat at top. Enter $1:$3 or just point to those three rows. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote: If I have a long spread sheet and I want to print it and see the top three rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS - Print - Headers
That's a different setting.
File|Page setup|Sheet tab|Uncheck Row and column headings But this can be very useful when you're double checking data entry. (Kind of ugly on the final report, though???) Dave wrote: Dave, Gord, Thanks, but now when I print I also see the A B C D etc... across the top. I don't want that. -- Dave "Gord Dibben" wrote: FilePage SetupSheetRows to repeat at top. Enter $1:$3 or just point to those three rows. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote: If I have a long spread sheet and I want to print it and see the top three rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS - Print - Headers
thanks
-- Dave "Dave Peterson" wrote: That's a different setting. File|Page setup|Sheet tab|Uncheck Row and column headings But this can be very useful when you're double checking data entry. (Kind of ugly on the final report, though???) Dave wrote: Dave, Gord, Thanks, but now when I print I also see the A B C D etc... across the top. I don't want that. -- Dave "Gord Dibben" wrote: FilePage SetupSheetRows to repeat at top. Enter $1:$3 or just point to those three rows. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 13:45:02 -0800, Dave wrote: If I have a long spread sheet and I want to print it and see the top three rows on each sheet I print without having to insert those three rows over and over again, how do I do that? Office XP -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
| Print Range headers and footers | Excel Discussion (Misc queries) | |||
| Excel 2007 worksheet headers do not print | Excel Worksheet Functions | |||
| Print column headers on select pages only | Excel Discussion (Misc queries) | |||
| Hide collapsed group headers on print | Excel Discussion (Misc queries) | |||
Linear Mode
