View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
column question column question is offline
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 ?)