Page 19 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

A new column is inserted to the left of column C. A new row is inserted above row 6.

After you've entered data, you may find that you need another column to hold additional information. For example, your worksheet might need a column after the date column, for order IDs.

Or maybe you need another row, or rows. You might learn that Buchanan, Suyama, or Peacock made more sales than you knew. That's great, but do you have to start over? Of course not.

To insert a single column, click any cell in the column immediately to the right of where you want the new column to go. So if you want an order-ID column between columns B and C, you'd click a cell in column C, to the right of the new location. Then on the Insert menu, click Columns.

To insert a single row, click any cell in the row immediately below where you want the new row to go. For example, to insert a new row between row 4 and row 5, click a cell in row 5. Then on the Insert menu, click Rows.

Excel gives a new column or row the heading its place requires, and changes the headings of later columns and rows.

Click Play to watch the process of inserting a column and a row in a worksheet.

In the practice you'll learn how to delete columns and rows if you no longer need them.

Page 19 of 22PREVNEXT