Microsoft Excel Columns and Rows

How do I delete and insert rows and columns?

You can easily delete or insert rows and columns in a worksheet even if they already contain data. Formulas will be automatically modified to compensate for the move.

To Delete:

	To delete a row, click in any cell in that row.
	Click the Edit, then click delete.
	The delete dialog box will appear.
	Click the Entire row option button.
	Click the OK button to delete the row.

Also:

	You can click on the gray row identifier button and Right click.
	The entire row will automatically be selected.
	Choose delete.
	That row will be gone.

Inserting a row:

	To insert a row, click any cell or select a row by clicking the gray row identifier button below the row you want to make.
	Click Insert, then click Rows.
	The new row is inserted above the selected row.

Also:

	You can click on the gray row identifier button and Right click.
	The entire row will automatically be selected.
	Choose insert.
	A new row will be inserted above the selected row.

Inserting and deleting columns:

Use the same procedures to insert and delete columns. New columns will be inserted to the left of the selected column.

Microsoft Excel

Tech Help

How do I delete and insert rows and columns?

To Delete:

Also:

Inserting a row:

Also:

Inserting and deleting columns: