Deleting Columns and Rows
Overview
When you delete a column from a sheet, the total number of columns does not decrease. Current data in the selected column is deleted and data in the columns to the right of the deleted column shifts left. A new blank column appears as the far right column of the sheet. If you want to decrease the number of columns in the sheet, change the maximum number of columns immediately after deleting a column. For more information on changing the maximum number of columns, see Setting the Maximum Number of Columns and Rows.
Similarly, when you delete a row from a sheet, the total number of rows does not decrease. Current data in the selected row is deleted and data in rows below shifts up. A new blank row appears as the bottom row of the sheet. If you want to decrease the number of rows in the sheet, change the maximum number of rows immediately after deleting a row. For more information on changing the maximum number of rows, see Setting the Maximum Number of Columns and Rows.
| Note: When you delete columns or rows in the Spread Designer, the total number of columns and rows does decrease by the number of columns and rows that you delete. |
When you delete 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.