O'Reilly logo

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

47-01.jpg

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required