How do I copy the setup from one sheet to another sheet in Excel

I did not understand what you mean by set up. . I asume you mean it to be
format
try this

1. go to your original file press ctr+A (Select all)
2. press ctr+c (copy)
3. go to the new file
4. press ctr+v (paste)
5. press del key ( it will delete all data)

what you get is the format of the original file without any data in it !




"Martina" wrote:

How do I copy the setup from one sheet to another sheet in Excel

Your subject line says "workbook" but your body text says "sheet".

To copy page setup from one sheet to all sheets within a workbook, just select
all sheets by right-click on a sheet tab then do your page setup on the active
sheet.

Will be done to all.

Note: exceptions..........print range cannot be set, rows to repeat at top
cannot be set.

For workbooks, there is no way except to create a template with your settings
then use that template as the basis for all new workbooks.


Gord Dibben MS Excel MVP

On Wed, 23 Apr 2008 21:09:00 -0700, Martina
wrote:

How do I copy the setup from one sheet to another sheet in Excel