ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Making a worksheet default (https://www.excelbanter.com/excel-discussion-misc-queries/136695-making-worksheet-default.html)

Per[_2_]

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

Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com