Add Columns in multiple Sheets

[Ken]

How do I insert a column in “sheet1†and then automatically have the same
column added into “sheet 2â€
Columns in “sheet 1†and “sheet 2†will have the same name.
I would like to add the column in-between “C†& “D†on “sheet 1 and fill in
a heading in cell in what will now be “D2†and them have the same happen in
“Sheet 2†without having to go “sheet 2†and repeating the process manually

 

[Pete_UK]

Group the two sheets and then apply the actions - they will occur on
both sheets. Then ungroup the sheets at the end.

To group the sheets, select Sheet1, hold the CTRL key and click on the
tab for Sheet2, then release CTRL. Now everything that you do in
Sheet1 will be reflected in Sheet2, so you can insert a new column D
and put a heading in D2 and this will be duplicated in the other
sheet(s).

To ungroup the sheets just right-click on one of the sheet tabs and
select Ungroup Sheets from the drop-down.

Hope this helps.

Pete

 

[Dave Peterson]

You can click on sheet1's tab (to select it).
Then ctrl-click on sheet2's tab.

You'll notice that both sheets are selected or grouped. In fact, excel tries to
warn you that you have grouped sheets by putting [Group] in the title bar.

Now you can insert the new column and add the header.

But remember to ungroup the sheets when you're done (select a different
sheet--or rightclick on either tab and choose Ungroup Sheets).

Almost any change you make to any member of a grouped sheet will be made to the
others.

Very useful for what you describe--but very dangerous if you forget!

ps.

You may want to put a formula in the new D1 of sheet2:
=if(sheet1!d1="","",sheet1!d1)

Then you'll only have to type the header once.

 

[Ken]

Thanks Pete & Dave.
This is how I have been doing it. I was Hoping there was a different way.
Thanks.

You can click on sheet1's tab (to select it).
Then ctrl-click on sheet2's tab.

You'll notice that both sheets are selected or grouped. In fact, excel tries to
warn you that you have grouped sheets by putting [Group] in the title bar.

Now you can insert the new column and add the header.

But remember to ungroup the sheets when you're done (select a different
sheet--or rightclick on either tab and choose Ungroup Sheets).

Almost any change you make to any member of a grouped sheet will be made to the
others.

Very useful for what you describe--but very dangerous if you forget!

ps.

You may want to put a formula in the new D1 of sheet2:
=if(sheet1!d1="","",sheet1!d1)

Then you'll only have to type the header once.

How do I insert a column in “sheet1†and then automatically have the same
column added into “sheet 2â€Â
Columns in “sheet 1†and “sheet 2†will have the same name.
I would like to add the column in-between “C†& “D†on “sheet 1 and fill in
a heading in cell in what will now be “D2†and them have the same happen in
“Sheet 2†without having to go “sheet 2†and repeating the process manually