Inserting Columns and Rows
Overview
When you insert a column in a sheet, the total number of columns does not increase. Current data in the selected column and in columns to the right shifts right and the last column in the sheet, including data, is deleted. To ensure that the data in the far right column is not deleted, increase the maximum number of columns in the sheet before inserting columns. For more information on changing the maximum number of columns, see Setting the Maximum Number of Columns and Rows.
Similarly, when you insert a row in a sheet, the total number of rows does not increase. Current data in the selected row and in rows below shifts down and the last row in the sheet, including data, is deleted. To ensure that the data in the bottom row is not deleted, increase the maximum number of rows in the sheet before inserting rows. For more information on changing the maximum number of rows, see Setting the Maximum Number of Columns and Rows.
| Note: When you insert columns or rows in the Spread Designer, the total number of columns and rows does increase by the number of columns and rows that you insert. |
When you insert columns or rows, the sheet automatically updates formulas in the sheet. For more information and instructions on turning off automatic updating, see Automatically Recalculating and Updating Formulas.