Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Making a worksheet default

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a worksheet a templete at_a_loss Excel Discussion (Misc queries) 1 February 24th 06 07:29 PM
Making Negative Results Default to Zero jcoleman52 Excel Discussion (Misc queries) 1 December 22nd 05 02:54 PM
Making Find go through worksheet only once Frank Marousek Excel Discussion (Misc queries) 3 April 27th 05 07:40 PM
help! making a worksheet more automated? redb Excel Discussion (Misc queries) 2 April 15th 05 01:53 PM
Track Changes: Making "All" the default Bettergains Excel Discussion (Misc queries) 0 January 11th 05 09:35 PM


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"