Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeat columns MiCoohs New Users to Excel 1 May 7th 06 02:51 PM
how do I make the first three rows repeat on top of every page? StardustDave New Users to Excel 2 January 29th 06 10:51 PM
How to print multiple columns on same page ocpsduke Excel Discussion (Misc queries) 2 October 8th 05 06:19 PM
How do you print selected columns on one page? Roadhand Excel Discussion (Misc queries) 4 September 14th 05 11:55 AM
Convert one row and 50 columns of info to a single printable page d5657 Excel Worksheet Functions 1 January 13th 05 01:17 PM


All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"