How to Create Your Own Formatting Style Template for Future Spreadsheets
April 18th, 2008In this short tutorial, you’ll learn how to create and save a styled template for your spreadsheets. If you want, for example, your future spreasheets to be written in red, bold, 14 pt. Comic Sans font and any other formatting specification, you can make this happen with the Style feature within Excel.
1.Go to File>Open and open an existing or a new spreasheet. Then go to Format>Style, and the Style pop up window will appear – as you can see, there are general specifications next to the formatting titles: Number, Alignment, Font, Border, Patterns, and Protection. Click on the Modify button, and the Format Cells pop up window will appear.
2.Next, make formatting changes within any of the tabs (Number, Alignment, Font, Border, Patterns and Protection) and click OK.
3.Now, you will see your new formatting specifications next to the Style’s main categories.
4.Finally, click on the Add button and give your new style specifications a name and click OK. Now the next time you create a spreadsheet and if you want to add this specific style to an existing spreadsheet, all you have to do is select the range of cells or the whole sheet, go to Format>Style, select the Style name and click OK. And the selected range or sheet will be automatically formatted to the style specifications previously saved.
Well Done! This table formatting feature can save you lots of time and make you look like a star in front of your co-workers.
No Comments
No comments yet.
Comments RSS TrackBack Identifier URI
Leave a comment
