Worksheet inheriting

kristinnj

Board Regular
Joined
Sep 14, 2004
Messages
91
Hello everybody

Heres my problem.
I have a document which has many worsheets which are basically all the same single form. Each one has a different head and and a different name of course. Now what I need to do is make the same changes to each and every worksheet as certain parts of the form have become outdated. Its gonna take a lot of time if I need to go to every worksheet and delete what i need to delete and add what I need to add so I was wondering if there was some "magical" way to do this, as I have so often found out via this message board.

Thanks
Kristinn J
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

cherria

Well-known Member
Joined
Nov 17, 2004
Messages
708
Yes, you select all the sheets. Right click on one of the sheet tabs and click select all.

Now every change you make to one sheet will happen to them all.

Remember to right click and ungroup sheets once you have finished.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,651
Members
414,399
Latest member
Ninjee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top