{"id":1929,"date":"2014-11-18T13:48:27","date_gmt":"2014-11-18T13:48:27","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=1929"},"modified":"2026-03-07T22:09:57","modified_gmt":"2026-03-07T22:09:57","slug":"using-the-total-cell-style-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-the-total-cell-style-in-excel\/","title":{"rendered":"Using the Total cell style in Excel"},"content":{"rendered":"

Trying to review a spreadsheet with unformatted data can be a real eye sore, but by using the Total cell style in Excel you can quickly give your data more context.<\/p>\n

An example of using the Total cell style in Excel<\/h2>\n

Below we have a list of sales figures for several\u00a0sales reps in a travel company. In just a few steps by applying the Total style helps the “Total” column of sales figures\u00a0stand out.<\/p>\n

\"Total<\/a>
Using a couple of Excel styles can make all the difference<\/figcaption><\/figure>\n

1.<\/strong> Select the range of cells you wish to format. Goto the Home tab, then the Styles group. Then click on the \u201cMore\u201d button \"the<\/a>\u00a0to expand the group. (for Excel 2013 & 2010 click on Cell Styles button, see the second screenshot below)<\/em><\/p>\n

\"Using<\/a>
How to select Total option from style section<\/figcaption><\/figure>\n
\"Using<\/a>
Selecting Cell Styles in Excel 2013 and 2010<\/figcaption><\/figure>\n

2.<\/strong> Now within the Style options, under the section, \u201cTitles and Headings\u201d just select the Total option. The selected range of cells will now display the Total formatting.<\/p>\n

In the example above, we also repeated these two steps for the row with \u201cJohn\u201d, and with one further twist, also included an additional style option under \u201cThemed Cell Styles\u201d which was to select a colour.<\/p>\n

Tip:<\/b> If you are experimenting with different styles you may wish to remove a cell style, to do this simply select the range of cells you wish to \u201creset\u201d, then go to the Style group (within the Home tab) and select Normal from the \u201cNormal, Bad, Good, Neutral\u201d section.<\/p>\n

\"how<\/a>
To\u00a0remove a style, just hit the Normal button<\/figcaption><\/figure>\n

What we have covered here is a simple demonstration of how using styles can lead to more engaging and professional-looking spreadsheets. You can even create your own custom cell styles which may contain multiple formatting options and can be a real time saver when dealing with similar spreadsheets. We teach this on our more advanced Excel courses London<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Trying to review a spreadsheet with unformatted data can be a real eye sore, but by using the Total cell style in Excel you can quickly give your data more context. An example of using the Total cell style in Excel Below we have a list of sales figures for several\u00a0sales reps in a travel […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[54,87,124,132,153,216,286,455],"class_list":["post-1929","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-apply-a-cell-style","tag-cell-styles-excel","tag-create-a-cell-style","tag-custom-cell-styles-excel","tag-delete-cell-styles-in-2010","tag-excel-style-function","tag-how-do-apply-a-total-cell-style","tag-remove-all-cell-styles-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1929"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1929\/revisions"}],"predecessor-version":[{"id":7887,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1929\/revisions\/7887"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}