Making Changes to the Worksheet
In a perfect society, you'd never need to edit your work. However, in the real world, you'll find yourself editing your
Editing Cell Contents
Editing cell contents is easy. Double-click the cell that you want to edit and make your changes. You can edit the existing cell contents or replace them. When you're done, press the Enter key or one of the directional arrows, or click the green check mark on the Formula bar to enter the new data into the cell. Cancel the edit by pressing Esc.
Clearing Cell Contents
Instead of editing a cell, you can clear the cell's contents. Clearing the contents of a cell is like using an eraser end of a pencil on the cell. Select the
Figure 2.10. Use the shortcut menu to clear the contents of a cell.
Inserting and Deleting
Deleting a cell and clearing a cell are two very different actions. Deleting a cell
Working with Rows and
Adding rows and columns to your worksheet does not change the maximum size of your worksheet. The worksheet cannot contain more than 65,536 rows or 256 columns.
The following exercise, in which you make some changes to the sales worksheet you started earlier, gives you a chance to put some of this knowledge to work. Don't worry if some of the changes don't make much sense; you're fine-tuning your skills right now. In later hours, you're going to
Highlight cells C6 through D6 on the sales worksheet and click the right mouse button.
Choose Clear Contents from the shortcut menu that appears. As you see, you can clear the contents of one
Let's add a row above row 7. From any column, select a cell in row 7, as shown in Figure 2.12. Because you're going to insert a row, you do not have to position the mouse pointer in a particular column.
When the row is highlighted, click the Insert menu and choose Rows. A blank row is inserted above the row you selected.
Click in cell A7, type Web Site , and press the right arrow to move to cell B7. Type 300 and press Enter.
Select cell B5, the cell that contains the Soft Cover sales amount and click Edit, Delete. The Delete dialog box, shown in Figure 2.13, appears. Make sure the option button
Stop now and save the worksheet so you can work with it later. Click the Save button on the Standard toolbar or click File, Save. When the Save As dialog box appears, type Sales 1st Qtr in the filename box and click Save.
If you're planning to go right on to the next