| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print headings/labels on every page
I'm trying to print 1 row and 3 column headings on every page. When I try it
under file/page setup/sheets I select the row to repeat at top then columns to repeat at left. When I try to print or preview I get the error message "print titles must be contiguous and complete rows or columns." What can I do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print headings/labels on every page
You can move the columns around so's they are contiguous.
Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 08:21:03 -0700, Rick Parker wrote: I'm trying to print 1 row and 3 column headings on every page. When I try it under file/page setup/sheets I select the row to repeat at top then columns to repeat at left. When I try to print or preview I get the error message "print titles must be contiguous and complete rows or columns." What can I do? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print headings/labels on every page
Mr. Dibben, thanks for your reply. I tried to make sure that the columns were
contiguous with each other and the row. It didn't work so I must still have it set up wrong. Would you mind if I sent you an example of what I am working with so that you can see what I have wrong? I don't want to just post it. Thanks "Gord Dibben" wrote: You can move the columns around so's they are contiguous. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 08:21:03 -0700, Rick Parker wrote: I'm trying to print 1 row and 3 column headings on every page. When I try it under file/page setup/sheets I select the row to repeat at top then columns to repeat at left. When I try to print or preview I get the error message "print titles must be contiguous and complete rows or columns." What can I do? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print headings/labels on every page
Rick
Send away. Change the dot and at appropriately. Gord On Wed, 12 Jul 2006 14:10:02 -0700, Rick Parker wrote: Mr. Dibben, thanks for your reply. I tried to make sure that the columns were contiguous with each other and the row. It didn't work so I must still have it set up wrong. Would you mind if I sent you an example of what I am working with so that you can see what I have wrong? I don't want to just post it. Thanks "Gord Dibben" wrote: You can move the columns around so's they are contiguous. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 08:21:03 -0700, Rick Parker wrote: I'm trying to print 1 row and 3 column headings on every page. When I try it under file/page setup/sheets I select the row to repeat at top then columns to repeat at left. When I try to print or preview I get the error message "print titles must be contiguous and complete rows or columns." What can I do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format to print in columns on 1 page | Excel Discussion (Misc queries) | |||
| Different print page setups on one worksheet? | Excel Worksheet Functions | |||
| How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
| How to print 2 Excel pages side by side on 1 printed page? | Excel Discussion (Misc queries) | |||
| How do you print selected columns on one page? | Excel Discussion (Misc queries) | |||
Linear Mode
