O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Examining Different Scenarios in a Worksheet

Often, when you've built a worksheet, you'll want to experiment with different data in it. For example, if you're setting budgets, you may need to play around with different figures for the different departments to get the overall balance you require.

You can experiment with different data by changing the values directly in your worksheet—but then you may need to restore your original values afterward. Another approach is to create multiple copies of the worksheet (or of the workbook) and then change the values in the copies, leaving the original untouched. This works fine, but if you then need to change the original worksheet (for example, adding another column of data), the changes quickly become ...

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