View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Making a worksheet default

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.

Per wrote:

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


--

Dave Peterson