If you add rows or columns to a spreadsheet Excel will automatically adjust named ranges to compensate.

Name: If you add rows or columns to a spreadsheet Excel will automatically adjust named ranges to compensate.
Brand: Quizplus
Rating: 4.8 (41 reviews)

Question

Quizplus · Accepted Answer

Named ranges in Excel do not automatically adjust when you add rows or columns outside of the named range. You must manually adjust the range or use dynamic named ranges with formulas to accommodate such changes.

If You Add Rows or Columns to a Spreadsheet Excel