If you are looking to enter stuff in the same cells on all sheets then click
on the first, hold the shift key down and click on the last and enter the
data you want. This will have highlighted all the sheets between the clicks
and [Group] will appear in the workbook header.

You can also use the Ctrl key rather than shift to highlight non-contiguous
sheets.

You can either click on a non-selected sheet tab to -un-group them or
right-click on a selected one and select 'un-group'

Hope that's what you meant

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"jstluv2smile" wrote in message
...
What must I do in order to repeat a row on each page of my spreadsheet?
Can you help? Thanks!