To ensure every other row is shaded and that this formatting updates automatically when new rows are added, you should use theBanded Rowsfeature within theTable Designoptions.

Since your data is already formatted as a Table (indicated by the filter arrows in the header row), follow these steps:

Step-by-Step Solution

Select the Table: Click anywhere inside the data on theSoldworksheet (for example, cellB5). This will make the contextual "Table Design" tab appear in the Ribbon.

Go to Table Design: Click on theTable Designtab at the top of the Excel window.

Enable Banded Rows: In theTable Style Optionsgroup, check the box labeledBanded Rows.

Why this works:

Automatic Updating: Because this is a Table feature rather than manual cell shading, if you insert a new row between existing data, Excel will automatically re-calculate the "every other row" pattern to maintain the shading.

Consistency: This method ensures that even if you sort or filter the data, the alternating stripes remain consistent visually.

Verification

Look at your table; you should see that rows 4, 6, 8, etc., have a different background color than rows 5, 7, 9. Try right-clicking a row and selectingInsertto see how the shading shifts automatically to maintain the pattern.