Microsoft Office Tutorials and References
In Depth Information
Customizing the Default Workbook
Customizing the Default Workbook
When you create a new Excel workbook, you get a standard default workbook. What if you don’t
like that workbook? For example, you may prefer a workbook with only one worksheet. Or, maybe
you don’t like the default font or font size. Perhaps you prefer to have the gridlines hidden in your
worksheets. Or, maybe you have a standard header that you always use on printed pages.
As it turns out, Excel gives you quite a bit of control in this area. You can make some changes in
the Excel Options dialog box. Other changes require a template.
Changing defaults in the Excel Options dialog box
The General tab of the Excel Options dialog box has four setting that control new workbooks
(see Figure 15-1).
Figure 15-1: Use the Excel Options dialog box to change some settings for new workbooks.
You can specify the font, font size, view, and number of worksheets. When you change any of
these settings, all new workbooks will use those settings. Changing these settings will not affect
workbooks that you’ve already created.
Creating a book.xltx template
For a new workbook setting that can’t be specified in the Excel Options dialog box, you need to
create a custom template file named book.xltx and then save that file to the proper location
on your hard drive.
Search JabSto ::

Custom Search