If you have 2+ workbooks open, how do you add a row?

Question

If you have 2+ workbooks open, how do you add a row?

Answer 1

Hi MC

I haven't received any updates since your message. Has everything been resolved yet?

Answer 2

Hi MC,

Thank you for your question to Microsoft Q&A Forum. Having multiple Excel workbooks open at the same time doesn’t change how rows are added, the key is simply to make sure you’re working in the correct workbook and worksheet.

To add a row when you have two or more workbooks open:

1. Click anywhere inside the workbook and worksheet where you want the new row (this makes it the active window).
2. Select the row number below where you want the new row to appear.
3. Right‑click the row number and choose Insert, or go to Home > Insert > Insert Sheet Rows.

Excel will only insert the row in the active workbook, even if other workbooks are open.

If you’re trying to keep rows synchronized automatically between different workbooks, Excel doesn’t do this by default, that would require linked tables, Power Query, or VBA.

Let me know which scenario applies to you, and I’ll be happy to help further.