Adding new data sets to multiple worksheets [Solved/Closed]

 Aaron -

I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the worksheets are formatted Identically. I want to be able to add a new data criteria (new Rows) in the Master Format" and have that formatting carry through to all the other worksheets.

for example if my rows are as follows in every sheet,

company | Address | Phone|

I want to be able to add "Cell Phone" to the Master sheet and have all other sheets add that same Row. The data wont be populated, but you now have the option to instead of adding a new row individually to 20 different worksheets.


1 reply

Registration date
Sunday September 12, 2010
Last seen
April 22, 2021
Hi Aaron,

By holding down the Ctrl button when selecting every single sheet, you can adjust all your sheets at the same time. Try it out.

Best regards,
I love trying to make things more complicated then they need to be. Thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!