Learn Excel 2011 for Mac

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