Inserting and deleting rows and columns

In this lesson

1. 1. Insert a row

   You forgot a cost between Rent and Salaries. Make space with a new row.

   A new row goes above the row you choose.

2. 2. Fill the new row

   The new row is empty. Add the missing cost.

3. 3. Insert with the keyboard

   First select the whole row. Then use the shortcut.

4. 4. Delete a row

   Row 2 is empty and not needed. Delete it.

5. 5. Insert a column

   Columns work the same way. A new column goes to the left of the one you choose.

6. 6. Try it yourself

   We do not need the Code column after all.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.