View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oldchippy oldchippy is offline
external usenet poster
 
Posts: 1
Default Rows to repeat on each page


jpreman Wrote:
Thanks for reading this post.

Is there any way I could repeat, for instance rows 1, 3 & 6 of a
worksheet,
on each page? (i.e. rows 2, 4 & 5 should not repeat on each page)

Thanks

Hi jpreman,

If you click your first page tab, then while holding the ctrl key,click
the other tabs, this forms a group.

so what ever you type on the first page in rows 1, 3 or 6 will also
appear on the other sheets. To unselect the group, right click
unselect sheets

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=572139