creating duplicate formats for worksheets

[lost_in_excel]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I want to format one worksheet, with the columns, rows, etc and then be able to use that Same format for several other worksheets automatically in the same workbook

 

[Fergal Condron]

Hi there,

If you select the current sheet tab and control click on it, then select
'Move or copy...'. Ensure that your Workbook is selected and that the
'Create a copy' check box is selected and click OK.

Thanks!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

 

[CyberTaz]

Another option:

Create however many blank worksheets you need, than with Sheet1 selected
Shift+Click the last sheet tab to select them all. When you make your
changes in Sheet1 they will "drill down" to all the other selected sheets.

HTH |:>)
Bob Jones
[MVP] Office:Mac