Name the file book.xltx (or.xltx if contains macros) and make sure the file is saved to your XLStart folder. Office>Save As>Select Template ( *.xltx) or (*.xltm) if your work book has any macros.
Once you have chosen your new settings you need to set your new work book up as your default. If you want to change the style completely then right click the name in the Style gallery and hit Modify then make the changes.
By default all cells use the ‘Normal’ style so if you want to change the default font in any way including the borders, number formats, or color then amend the Normal style.
Let’s start customizing a new blank work book. 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. 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. 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. When you create or open a new work book in Excel, you are presented with Excel’s default standard version. Want to create your own style Excel work book to re use over and over again? It is easy to create your own default template in Excel to fit in with your corporate style or your own personal style.
0 kommentar(er)
