Not sure if this is possible, but have to ask.

I have a very large spreadsheet (workbook) we use to track data for multiple
companies. Each company has their own individual worksheet (TAB), however
every worksheet looks exactly the same. (Same column headers, rows, etc.)
Just a different company name.

Is it possible to add a new column in the first worksheet and have it
automatically (or somehow) get added to each of the other worksheets.

Thanks for any help with this.

Highlight all the tabs and then insert a column where you want a new column.

You can either highlight all tabs: make sure you are on the first tab, hold
your shift button down and then click on the last tab (and then release shift
button).
Or: you can choose certain tabs by holding ctrl button down and clicking on
the tabs you want to change.

"Big_Tater" wrote:

Not sure if this is possible, but have to ask.

I have a very large spreadsheet (workbook) we use to track data for multiple
companies. Each company has their own individual worksheet (TAB), however
every worksheet looks exactly the same. (Same column headers, rows, etc.)
Just a different company name.

Is it possible to add a new column in the first worksheet and have it
automatically (or somehow) get added to each of the other worksheets.

Thanks for any help with this.

Right-click on a sheet tab and "Select all sheets"

Insert a column on the activesheet and will be done to all.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 08:04:16 -0800, Big_Tater
wrote:

Not sure if this is possible, but have to ask.

I have a very large spreadsheet (workbook) we use to track data for multiple
companies. Each company has their own individual worksheet (TAB), however
every worksheet looks exactly the same. (Same column headers, rows, etc.)
Just a different company name.

Is it possible to add a new column in the first worksheet and have it
automatically (or somehow) get added to each of the other worksheets.

Thanks for any help with this.

Thanks for the help Gord. That's so simple I can't believe I didn't think of
trying that.

"Gord Dibben" wrote:

Right-click on a sheet tab and "Select all sheets"

Insert a column on the activesheet and will be done to all.


Gord Dibben MS Excel MVP

On Mon, 2 Mar 2009 08:04:16 -0800, Big_Tater
wrote:

Not sure if this is possible, but have to ask.

I have a very large spreadsheet (workbook) we use to track data for multiple
companies. Each company has their own individual worksheet (TAB), however
every worksheet looks exactly the same. (Same column headers, rows, etc.)
Just a different company name.

Is it possible to add a new column in the first worksheet and have it
automatically (or somehow) get added to each of the other worksheets.

Thanks for any help with this.

Thanks for the quick response "aquaxander". That's exactly what I was looking
for and will make the rest of my day much smoother.

"aquaxander" wrote:

Highlight all the tabs and then insert a column where you want a new column.

You can either highlight all tabs: make sure you are on the first tab, hold
your shift button down and then click on the last tab (and then release shift
button).
Or: you can choose certain tabs by holding ctrl button down and clicking on
the tabs you want to change.

"Big_Tater" wrote:

Not sure if this is possible, but have to ask.

I have a very large spreadsheet (workbook) we use to track data for multiple
companies. Each company has their own individual worksheet (TAB), however
every worksheet looks exactly the same. (Same column headers, rows, etc.)
Just a different company name.

Is it possible to add a new column in the first worksheet and have it
automatically (or somehow) get added to each of the other worksheets.

Thanks for any help with this.