Working with Workbook Files
- Starting with an Excel Workbook Template
- Creating Workbooks from Scratch
- Saving and Naming Your Workbook
- Saving a Workbook as a Template
- Opening a Saved Workbook
- Managing Worksheets
This chapter is from the book
This chapter is from the book
This chapter is from the book
In this chapter
- Starting a project with one of Excel's sample workbooks.
- Creating a blank workbook.
- Saving and opening workbook files.
- Creating your own worksheet templates.
- Creating, naming, and customizing the worksheets in a workbook.
Every file you create in Excel is a workbook, consisting of one or more worksheets. You can create workbooks from scratch by choosing to create a blank workbook, or you can use any of Excel's many workbook templates to start your own workbook and then customize it to suit your needs. You can even add worksheets to a workbook to accommodate additional data. In this chapter, you learn how to work with Excel workbook files and add, delete, and rearrange worksheets in a workbook.
Starting with an Excel Workbook Template
Each time you start Excel, it opens a blank workbook, so you can begin entering data immediately. However, you might be able to save yourself a considerable amount of time by creating a new workbook based on one of the many templates included with Excel. Excel features templates for creating expense statements, invoices, purchase orders, income statements, and other commonly used worksheets. Each template is professionally designed and contains the formulas and functions required to perform the necessary calculations. Rather than start from scratch, you can open a workbook template and then customize the workbook, or, if the workbook is exactly what you need, simply start adding your data.
To open an Excel template that was installed with the Excel program, follow these steps:
-
Open the File menu and choose New. The New Workbook task pane appears, as shown in Figure 3.1.
-
Under Templates, click On My Computer. The Templates dialog box appears.
-
Click the Spreadsheet Solutions tab. Excel displays a small collection of spreadsheet templates, as shown in Figure 3.2.
-
Click the desired template and click OK. Excel installs the selected template and then opens it, so you can begin working. (If prompted, insert the Excel or Office installation CD and click OK.)
)
Figure
3.1 To save time, use one of Excel's sample spreadsheet templates.
)
Figure
3.2 To save time, use one of Excel's sample spreadsheet templates.
If you have an Internet connection, you can connect to Microsoft's Templates Home and obtain dozens of other useful templates for both home and business applications. The Templates Home features templates for all Microsoft Office applications, including Excel, Word, Access, and PowerPoint. Each template is marked with an icon for the program used to create it, so you can determine which templates are designed exclusively for Excel. Excel's New Workbook task pane provides easy access to these templates, as these steps demonstrate:
Open the File menu and choose New. The New Workbook task pane appears.
Under Templates, click Templates on Office Online. Excel automatically runs your Web browser, which connects you to Microsoft.com. This connects you to the Templates Home.
-
Scroll down the page and click the desired template category, as shown in Figure 3.3, to display a list of subcategories, including the number of templates available in each subcategory.
-
Click the link for the desired subcategory to display a list of available templates, as shown in Figure 3.4. Note that the icon next to each template name indicates the application used to create it: Excel, Word, Access, or PowerPoint.
-
Click the link for the desired template, so you can check it out before downloading (copying) it. Your Web browser displays a preview of the template, as shown in Figure 3.5.
Click Download Now. The End User License Agreement appears, notifying you of your rights and responsibilities in using this template.
Read the License Agreement, and (assuming you agree) click Accept. The first time you download a template, Microsoft displays another screen explaining that you must download an ActiveX control to use the template.
If a dialog box pops up asking whether you want to allow the ActiveX control to run on your computer, make sure the control is licensed through Microsoft, and then click Yes to approve the download. You are then returned to the Web page.
-
Click Continue. Your Web browser downloads the template and opens it in Excel, as shown in Figure 3.6, so you can start using it or modifying it.
)
Figure
3.3 With an Internet connection, you can obtain templates online.
)
Figure
3.4 The Templates Home features templates for all Office applications.
)
Figure
3.5 The Templates Home lets you preview a template before opening it.
)
Figure
3.6 Excel opens and displays the template you chose to download.
NOTE
In the New Workbook task pane, below Templates is the option On My Web Sites. In most cases, you can safely ignore this option. If you set up Web sites in Windows, however, and these sites contain additional Excel templates, you can use the On My Web Sites option to quickly access these templates from Excel.