Microsoft Office Tutorials and References
In Depth Information
Working with Template Files
Workspace files
A workspace file is a special file that contains information about an Excel workspace. For
example, if you have a project that uses two workbooks and you like to have the workbook windows
arranged in a particular way, you can save an XLW file to save this window configuration. Then,
whenever you open the XLW file, Excel restores the desired workspace.
To save a workspace, choose View➜Window➜Save Workspace and provide a name when
prompted.
To open a workspace file, use File➜Open and select Workspaces (*.xlw) from the Files of Type
drop-down list.
It’s important to understand that a workspace file does not include the workbooks — only the
configuration information that makes those workbooks visible in your Excel workspace. So if you
need to distribute a workspace to someone else, make sure that you include the workbook files
as well as the XLW file.
Working with Template Files
A template is essentially a model that serves as the basis for something else. An Excel template is
a workbook that’s used to create other workbooks. You can save any workbook as a template file
(XLTX extension). Doing so is useful if you tend to create similar files on a regular basis. For
example, you might need to generate a monthly sales report. You can save some time by
creating a template that holds the necessary formulas and charts for your report. When you start new
files based on the template, you need only to plug in the values.
Viewing templates
Excel gives you access to many templates. To explore the Excel templates, choose File New to
display the Available Templates screen.
The Office Online Templates section contains a number of categories. Click a category, and you’ll
see the available templates. To use a template, select it and click Download. Figure 4-3 shows
some of templates available in the Invoices category.
 
Search JabSto ::




Custom Search