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

Clear the Values

At this point, all three sheets are identical except for their names. We need to clear out the values in the February and March sheets, leaving the labels and formulas, so we can enter new values. Because the two sheets are identical and the values are in the same cells in both sheets, we can clear the values in both sheets at the same time.

Click the February tab to activate that sheet.

Hold down the Ctrl (Windows) or Command (Mac OS) key and click the March tab.

Both tabs become selected (they turn white)...

...and [Group] appears beside the workbook name in the title bar.

Position the mouse pointer on cell B3, press the mouse button, and drag down to cell C5 to select all of the cells with income values.

Choose Contents from the Clear submenu under the Edit menu.

The cells' contents are removed.

Position the mouse pointer on cell B8, press the mouse button, and drag down to cell C26 to select all of the cells with expense values.

Choose Contents from the Clear submenu under the Edit menu (shown on previous page).

The cells' contents are removed.

Click the January tab to clear the group selection. You can then click the February tab to work with just that worksheet.

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