Removing Rows and Columns

Removing Rows and Columns

When you delete a row in your worksheet, the rows below the deleted row move up to fill the space. When you delete a column, the columns to the right shift left.

Follow these steps to delete a row or column:

  1. Click the row number or column letter of the row or column you want to delete. You can select more than one row or column by dragging over the row numbers or column letters .

  2. Select the Edit menu and then select Delete . Excel deletes the rows or columns and renumbers the remaining rows and columns sequentially. All cell references in formulas and functions are updated appropriately.

Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: