Check Templates / December 18, 2018 / Lea Melton
Look at the task pane on right of your workbook and type your criteria in the search online box. (This works as long as you have an internet connection). Click Go and see the several templates it returns. Select the one you want to use and click on download. Once downloaded this template can be modified saved and re-used as often as you need it. When you create or open a new work book in Excel you are presented with Excel s default standard version. You may not like that style. You may prefer to have just one worksheet a different font or background color or indeed a standard corporate heading that is on all of your spreadsheets.
If you want to change the style completely then right click the name in the Style gallery and hit Modify then make the changes. Once you have chosen your new settings you need to set your new work book up as your default. This is straightforward:- Office>Save As>Select Template ( *.xltx) or (*.xltm) if your work book has any macros. Name the file book.xltx (or.xltx if contains macros) and make sure the file is saved to your XLStart folder. Excel states it should be saved in your Templates folder but ensure it is saved in your XLStart folder. After you save the file close it.
Look on the left side of your new window screen until you see Microsoft Office Online. Click on the category that you are interest in (for example budgets calendar etc) You will see templates appear for that category. Select the template that looks interesting to you. Click OK. Once downloaded this template can be modified saved and re-used as often as you need it. Excel 2003 Excel 2003 has templates located on your computer and ones that can be downloaded directly from Microsoft.com. Downloading templates to Your Computer To download templates directly to your computer follow these steps: Select File and then New.