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

Setting Preferences for Creating and Saving Your Workbooks

One thing you're pretty much certain to do in Excel is create workbooks and save them. So it's worth spending a minute or two to set Excel to create workbooks with the right number of worksheets, using the folder and workbook format you prefer. You'll also want to choose where to save your workbooks and whether to keep automatic backups as you work. You can also have Excel prompt you to enter property information in your workbooks to make them easier to identify.

Creating Workbooks with the Number of Worksheets You Need

When you create a new workbook, Excel gives it a single worksheet by default. You can add as many other worksheets as you need by clicking the Insert Sheet button, but ...

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