Inserting Columns Across Multiple Worksheets
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.
|