• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Enter New Values

The February and March worksheets are ready for their values. We'll follow the same basic steps on pages 3132 to create entry areas and enter the data. To prevent ourselves from accidentally overwriting the formulas in cells B6 and C6, we'll create two separate entry areas for each worksheet.

Click the February sheet tab to activate that sheet.

Drag from cell B8 to C27 to select that range of cells.

Hold down the Ctrl (Windows) or Command (Mac OS) key and drag from cell B3 to C5 to add that range to the selection.

Enter the values shown here in each cell. Be sure to press Enter (Windows) or Return (Mac OS) to advance from one cell to the next. Pay attention; Excel will go through the cells in the top selection before it begins activating cells in the bottom selection.

Click the March

Repeat steps 2-4 for cells B8 to C25 and B3 to C5, entering the values shown here.

Have you been saving your work?

Now is a good time to click the Save button on the Standard toolbar to save your work up to this point.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint