Page 20 of 23PREVNEXT

Get to know Excel 2007: Create your first workbook

Click Play to see a new column inserted to the left of column C, and a new row 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 Home tab, in the Cells group, click the arrow on Insert. On the drop-down menu, click Insert Sheet Columns. A new blank column is inserted.

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 in the Cells group, click the arrow on Insert. On the drop-down menu, click Insert Sheet Rows. A new blank row is inserted.

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 20 of 23PREVNEXT