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