Stop your formulas from breaking by switching from grid-based coordinates (ROW) to stable table measurements (ROWS).
Rows in Microsoft Excel change their height to fit their contents. For example, if each cell in the row contains a single word, the row will keep its default height of 15 pixels. If cells contain ...
Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.