Click Create to download the template. Excel creates the workbook Academic calendar (any year)1.xlsx based on this template. Create a Template. If you create your own template, you can safely store it in the Templates folder. As a result, you can create new workbooks based on this template without worrying that you overwrite the original file. KTM Motocross Vector Templates Showing 1–12 of 44 results Default sorting Sort by popularity Sort by average rating Sort by latest Sort by price: low to high Sort by price: high to low.
MS-Excel / Getting StartedThe term default template may be a little misleading. If you haven't created your own template files to control the default settings, Excel uses its own internal settings-not an actual template file. In other words, Excel uses your template files to set the defaults for new workbooks or worksheets, if these files exist. But if you haven't created these files, Excel is perfectly happy to use its own settings.
Using the workbook template to change workbook defaults
Every new workbook that you create starts out with some default settings. For example, the workbook has three worksheets, the worksheets have gridlines, text appears in the fonts specified by the default document template. columns are 8.43 units wide, and so on. If you're not happy with any of the default workbook settings, you can change them.
Making changes to Excel's default workbook is fairly easy to do, and it can save you lots of time in the long run. Here's how you change Excel's workbook defaults:
- Open a new workbook.
- Add or delete sheets to give the workbook the number of worksheets that you want.
- Make any other changes that you want to make, which can include column widths, namedstyles, page setup options, and many of the settings that are available in the Excel Optionsdialog box. To change the default formatting for cells, choose Home> Styles> Cell Styles andthen modify the settings for the Normal style. For example, you can change the default font, size, or number format.
- When your workbook is set up to your liking, choose Office button> Save As.
- In the Save As dialog box, select Template (*.xltx) from the box labeled Save As Type. Ifyour template contains any VBA macros, select Excel Macro-Enabled Template (*.xltm).
- Enter book for the file name.
Excel will offer a name such as Book1.xlt. You must change this name to book.xlt (or book.xltm) if you want Excel to use your template to set the workbook defaults. - Save the file in your XLStart folder.
The XLStart folder may be located in either of these directories:C:Documents and Settings<username>Application DataMicrosoftExcelXLStart
C:Program FilesMicrosoft OfficeOffice12XLStart - Close the file.
After you perform the preceding steps, the new default workbook is based on the book.xltx (orbook.xltm) workbook template. You can create a workbook based on your template by using any of these methods:
- Press Ctrl+N.
- Open Excel without first selecting a workbook to open.
- Choose Office button> New and choose Blank Workbook.
If you insert a new worksheet into a workbook that's based on the book.xlxt template, thenew worksheet will notuse the customized settings specified in the template. Therefore, youmay also want to create a sheet.xltx template, which controls the settings for new worksheets.
If you ever want to revert to the standard default workbook, just delete the book.xltx file.
Using the worksheet template to change worksheet defaults
When you insert a new worksheet into a workbook, Excel uses its built-in worksheet defaults for the worksheet. These default settings include items such as column width, row height, and so on.
If you don't like the default settings for a new worksheet, you can change them by following these steps:
- Start with a new workbook and delete all the sheets except one.
- Make any changes that you want to make, which can include column widths, named styles,page setup options, and many of the settings that are available in the Excel Options dialog box.
- When your workbook is set up to your liking, choose Office button> Save As.
- In the Save As dialog box, select Template (*.xltx) from the Save As Type box.
- Enter sheet.xltx for the filename.
- Save the file in your XLStart folder.
- Close the file.
- Close and restart Excel.
After performing these steps, all new worksheets that you insert by using any of these methods will be formatted like your sheet.xltx template:
- Clicking the Insert Worksheet button (next the last sheet tab).
- Choosing Home> Cells> Insert> Insert Sheet.
- Pressing Shift+F11
- Right-clicking a sheet tab, choosing Insert from the shortcut menu, and choosing the Worksheeticon in the Insert dialog box.
Editing your templates
After you create your book.xltx or sheet.xltx templates, you may discover that you need to change them. You can open the template files and edit them just like any other workbook. After you make your changes, save the file, and close it.
Resetting the default workbook and worksheet settings
If you create a book.xltx or sheet.xltx file and then decide that you would rather use the standard default settings, simply delete the book.xltx or sheet.xltx template file-depending on whether you want to use the standard workbook or worksheet defaults-from the XLStart folder. Excel then uses its built-in default settings for new workbooks or worksheets.
You can also rename or move the template files if you'd like to keep them for future use.
In this tutorial:
While you may know Microsoft Excel for its ability to create versatile spreadsheets and colorful charts, you can also use it to create custom calendars. In Excel 2007, you can insert a calendar control that makes it fast and simple to find and insert dates into a worksheet. Another option is to use a template to create a personalized, printable calendar within Excel.
Add Calendar Control to Worksheet
Display the 'Developer' tab of the ribbon. Click the 'Office Button.' Click the 'Excel Options' button. Select the 'Show Developer Tab in the Ribbon' check box under 'Popular Options.' Click 'OK.'
Go to the 'Developer' tab. Click Insert and choose 'ActiveX Controls.'
Click 'More Controls' and select 'Calendar Control' in the 'More Controls' list. Click 'OK.' Excel inserts a calendar control in 'Design View,' which allows you to edit and customize the control.
Right-click the Calendar Control and click 'Calendar Object.' Select 'Properties' to open the 'Calendar Controls Properties' dialog box. Select options for the font, color and other aspects of the control. Click onto the worksheet when finished.
Click on the calendar control and click on the date you want to add to the worksheet. Excel automatically enters the date into the selected cell.
Make Printable Calendar from Template
Click the 'Office Button' and select 'New.'
Type 'calendar' into the 'Search Templates on Office Online' box. Press the 'Enter' key. A gallery of template options opens.
Select the calendar template you want to use. Click the 'Download' button. The calendar opens as a new Excel file.
Click inside of a date on the calendar to which you want to add a note or reminder. Type directly into the empty space on that date. Go to the 'Page Layout' tab. Click 'Themes.' Click the 'Colors' drop-down arrow to select a different color scheme. Select 'Fonts' to change the fonts on the calendar.
Click the 'Save' button on the 'Quick Access Toolbar,' enter a name for the calendar and click 'Save.' Print the calendar if desired.
Video of the Day
Brought to you by Techwalla
- calendar for 2007 (august) image by Sergey Galushko from Fotolia.com