Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print cells at the top
I've posted this question but i havent seen an answer. ive been told this
group has the smartest and brightest people i am trying to have excel print cells a1:m10 at the top of each page that is printed. i can't use the page setup... header because some of the cells in that range refer to another sheet. i also can't use the "print titles" in sheet because i only want that range of cells and not the entire row/column to appear on each printed page. is there a macro or non-macro solution to have ONLY that range of cells appear in every page that is printed in the sheet? the sheet extends over multiple pages and the number of pages the sheet has varies from report to report thanks in advance for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print cells at the top
The print titles option only prints the rows as far as the underlying print
area. So if your normal print area spans columns a to m your print titles will also only show the required area A1 to m10 Send me a file if that still wouldn't work and I'll have a look. -- Greetings from New Zealand "karimhemani" wrote in message ... I've posted this question but i havent seen an answer. ive been told this group has the smartest and brightest people i am trying to have excel print cells a1:m10 at the top of each page that is printed. i can't use the page setup... header because some of the cells in that range refer to another sheet. i also can't use the "print titles" in sheet because i only want that range of cells and not the entire row/column to appear on each printed page. is there a macro or non-macro solution to have ONLY that range of cells appear in every page that is printed in the sheet? the sheet extends over multiple pages and the number of pages the sheet has varies from report to report thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting cells to show on print preview & print out | Excel Discussion (Misc queries) | |||
How can I set some cells to not print w/o changing print layout? | Excel Discussion (Misc queries) | |||
Not print certain cells | Excel Discussion (Misc queries) | |||
How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
print view & print, in excel, different size cells | Excel Discussion (Misc queries) |