Inserting Rows and Columns

In ad hoc grids, calculating and non-calculating columns and rows may be inserted within or outside the grid. Inserted rows and columns may contain formulas, text, or Excel comments, and are retained when you refresh or zoom in.

Always refresh the grid before inserting rows or columns.