4. duplicate the worksheet

So far, we’ve created a budget worksheet for one month. Our project, how- ever, includes budget worksheets for three months.

While you could simply repeat the steps in Chapter 3 twice to create two more worksheets, there is a better—and quicker—way. You can duplicate the January worksheet, clear out the values you entered, and enter new values for February. You can then do the same thing for March.

In this chapter, we’ll do just that. But just to make things interesting, we’ll add and remove a couple of expense categories. As you’ll see, this will make the consolidation process in Chapter 5 a bit more challenging.


Get Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.