Making a worksheet default

P

Per

Hi

I have med a worksheet with a lot of changes -
CAN excel be set up too
when i press make a new worksheet the new worksheet will be like the ohter
worksheet with all the changes in ????

and I also need it to be - when I have lets say 20 worksheet
I only need to make changes too one worksheet then it will change on them all

Please help

/per
 
D

Dave Peterson

You can use Edit|move or copy sheet to copy a sheet that's set up the way you
want.

And if you have headers that are common across all the sheets, you could use a
formula on the "receiving" sheets:

=sheet1!a1

But I've only see this work effectively with stuff that doesn't change--row and
column headers mostly.
 
Top