How do I insert rows in multiple excel tables simultaneously without vba?

I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?

The tables are in different sheets if that matter.

You can make changes to multiple sheets simultaneously by selecting multiple tabs.

If you want to insert a row at the same point in all sheets, you can do the following.

• Select all of the tabs at the bottom of the workbook.
• Select the row below where you want the new row inserted.
• Right click and choose insert from the menu.

You now have a new row in all the selected sheets.

NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.