ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to repeat top columns each page (https://www.excelbanter.com/excel-worksheet-functions/121652-how-repeat-top-columns-each-page.html)

column question

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

Roger Govier

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




column question

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 ?)



All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com