Check Templates / December 18, 2018 / Magdalena Schultz
If you want to stay away from the default Excel is very flexible and gives you a lot of options to make your workbooks your own. It is easy to create a new default work book all you need to do is create a new custom template save the file as book.xltx and save the file to it s correct location on your hard drive. Let s start customizing a new blank work book. Here are a list of some of the main items you can change to customize your template. Number Of Sheets- You can add extra sheets or delete sheets. I like to default my work books to one sheet. You can also change the names. Office>Excel Options>Popular Tab and select your options.
Also any bonuses that are added on to your salary are also to be mentioned. Your pay check stub template will help you to understand why there is an increase or decrease in your salary. It is essential that you understand these templates or you will be left wondering about the fluctuations in your salary. There are many such templates available however most companies will follow a general pattern of templates that will have all the details of the salary of the employees. If you have any queries on your pay check then this document should be able to clear out all your doubts about the money you are earning.
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.