Data Analysis with Microsoft Excel: Updated for Office 2007

40 Excel

Inserting New Data

Sometimes you will want to add new data to your data set. For example,

you discover that there is a tenth service station with the following

sales data:

Table 2-2 Additional Service Station Sales

Station Gas Other

0 $8,995 $6,938

You could simply append this information to the table you’ve already

created, covering the cell range A11:C11. On the other hand, in order to

maintain the sequential order of the station numbers, it might be better to

place this information in the range A2:C2 and then have the other stations

shifted down in the worksheet. You can accomplish this using Excel’s Insert

command.

To insert new data into your worksheet:

1 Select the cell range A2:C2.

2 Right-click the selected range and then click Insert from the pop-up

menu. See Figure 2-4.

Figure 2-4

Running

the Insert

command

from the

shortcut

menu