![]() |
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 |
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