Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat top columns each page
Tell us how to fill in the "rows to repeat, since this ASININE program
doesn't accept logic, i.e. A1, A2 through H1 and H2, etc. or (A1, A2 - H1, H2) IT JUST GIVES AN ERROR MESSAGE. HOW STUPID ! !! ! ! !! NO HELP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat top columns each page
Hi
Just enter 1:6 or 3:10 You cannot have 2 ranges, it has to be one contiguous range. If you click the icon at the end of the dialogue, you can just point at the rows you want. -- Regards Roger Govier "column question" wrote in message ... Tell us how to fill in the "rows to repeat, since this ASININE program doesn't accept logic, i.e. A1, A2 through H1 and H2, etc. or (A1, A2 - H1, H2) IT JUST GIVES AN ERROR MESSAGE. HOW STUPID ! !! ! ! !! NO HELP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat top columns each page
"Roger Govier" wrote: Hi Just enter 1:6 or 3:10 You cannot have 2 ranges, it has to be one contiguous range. If you click the icon at the end of the dialogue, you can just point at the rows you want. -- Regards Roger Govier "column question" wrote in message ... Tell us how to fill in the "rows to repeat, since this ASININE program doesn't accept logic, i.e. A1, A2 through H1 and H2, etc. or (A1, A2 - H1, H2) IT JUST GIVES AN ERROR MESSAGE. HOW STUPID ! !! ! ! !! NO HELP Actually it requires $1:$2 (how would anyone know that ?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeat columns | New Users to Excel | |||
how do I make the first three rows repeat on top of every page? | New Users to Excel | |||
How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
How do you print selected columns on one page? | Excel Discussion (Misc queries) | |||
Convert one row and 50 columns of info to a single printable page | Excel Worksheet Functions |