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 ...

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.