• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Inserting and Deleting Rows

Inserting and Deleting Rows

After you click a cell above which you want to add a row, open the Insert menu and choose Rows.

A new row is inserted (notice the Insert Options Format Painter smart tag, which allows you to format the row like the one above it, below it, or to apply no formatting).

To delete a row, right-click the row header for the row you want to delete, and choose Delete from the shortcut menu that appears.

The row is deleted.

INTRODUCTION

You can insert extra rows into a worksheet to make more room for additional data or formulas. Adding more rows, which gives the appearance of adding space between rows, can also make the worksheet easier to read. Alternatively, you can delete rows from a worksheet to close up some empty space or remove unwanted information.


TIP

Automatic formula row updates

When you insert a new row, Excel automatically updates any formulas affected by the insertion (see Part 5 for more information).


TIP

#REF! error

If the #REF! error appears in a cell after you delete a row, it means you deleted a cell or cells that contained data that your worksheet needs to calculate a formula. To resolve the problem, undo the change (refer to the task “Undoing and Redoing Changes.”)


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint