Add the rows without crashing the existing rows below.

Question

I have one question

Below is filter table from R6 to R41.

When the new row is added to filter table it shifts below and crash with R43 & R44.

What shall i do so that when new row added to the filter table, then automatically the row added below without crashing with rows R43 & R44.

Answer 1

Hello, I'm Quinn and here to help!

Try this step-by-step guide:

1. Click on row number 42 on the far left edge of your screen, hold the click, and drag down to highlight rows 42, 43, and 44.
2. Right-click anywhere on that highlighted area and select Insert to push your Grand Total and green Check rows downward, creating your first 3 blank buffer rows.
3. Repeat this insert step 3 more times to create a much safer cushion of about 10 to 12 empty rows, which gives your table plenty of room to grow before it ever gets close to your checks again.
4. Use your mouse to highlight your entire data range, starting from the headers at Row 5 all the way down to the last data row at Row 41 (be careful not to include any of the new blank rows or the green check rows).
5. Press Ctrl + T on your keyboard to open the "Create Table" window.
6. Look closely at the selection box inside that window and verify that it correctly detected your full range from row 5 to row 41 before proceeding.
7. Check the box that says "My table has headers" and click OK to turn your data into an official Excel Table.
8. Click into the very last cell at the bottom right corner of your data table (Row 41, last column).
9. Press the Tab key on your keyboard to add a new row; Excel will now automatically expand the table downward into your empty buffer space while keeping your formulas below completely safe and untouched.

Answer 2

Hi @santosh chaturvedi, 

Thank you for posting your question in the Microsoft Q&A forum. 

I understand that you would like to insert a new row without affecting or disrupting the existing rows below. 

To assist you more effectively, could you please share the Excel file with me via private message? You can follow the steps provided in the private message instructions to upload and share the file. 

Please note that private messages are only visible to moderators, so your personal or organizational information will remain secure. 

Thank you again for your time and understanding. While my initial response may not fully resolve the issue yet, I’d like to review the file to gather more details and provide you with the most accurate solution. 

I truly appreciate your patience and look forward to your response. 

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread 

Answer 3

Insert blank rows between the filtered table and the rows at R43–R44 so that the table can expand without overwriting them, or convert the area R6:R41 into an Excel table and let Excel manage the resizing.

Two practical options:

1. Insert buffer rows below the table
   1. Select the entire row immediately below the table (currently R42).
   2. On the Home tab, select Insert > Insert Sheet Rows several times to create a block of blank rows between the table and rows R43–R44.
   3. Now, when new rows are added to the filtered range, Excel will shift the blank buffer rows down instead of overwriting R43–R44.
2. Convert the range to an Excel table and let it resize
   1. Select the range R6:R41.
   2. On the Insert tab, choose Table and confirm the range.
   3. Move any content currently in R43–R44 to rows well below the table.
   4. When new data is added:
      • Type in the first empty row directly below the table, or
      • Right‑click inside the table, choose Insert > Table Rows Above/Below. Excel automatically expands the table downward without affecting content that is not immediately adjacent.

If the table must remain adjacent to R43–R44, keep at least a few permanently blank rows between them as a safety margin.

---

References:

• Resize a table by adding or removing rows and columns in Excel
• Video: Add and delete table rows and columns
• Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet