View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Repeat title to top of each worksheet

The rows to repeat at top in print setup is only for printing.

Try this if you can't copy.

Select first sheet then right-click and "select all sheets"

Type your title across the top row of active sheet.

Will be done to all.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben MS Excel MVP

On Fri, 13 Jul 2007 09:22:12 -0700, Starla
wrote:

I need to put a title to the top of each worksheet in Excel 2003. I can not
use the copy command, and the filepage setupsheetsrow thing is not
working!