98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Topics » Total cell style in Excel 2010
Total cell style in Excel 2010
The total cell style feature in Excel 2010 makes it easy and quick for you to create professional and presentable data without having to manually highlight and format all the cells.
To apply the total cell style:
Go to the home tab and find the styles section. You now select the button called Cell Styles.
When you click this button, it will show a range of automatic cell styles to choose from. You can then select the style that meets your business requirement.
E.g. You may want to create a 5 year budget showing company expenses. For each block of expenses for each year, you could choose one of the cell styles to format the range. This enables you to easily identify a particular year by colour and makes the spreadsheet easier to read and interpret. It allows consistency which helps find and interpret data quickly and more efficiently.
Related forum posts:
How to autoformat in Excel 2007
How to autoformat in excel 2007
conditional formatting
I would really like to know how I would apply a conditional format to a row of data - i.e. if I have a list of values (revenue and costs) and the amount in the total column is 0 or less - how would I get the entire row to go red?
Excel 2007 - formatting cells
How would you highlight or emphasise any cells that contain a number that is higher than or lower than a specified value?
Styles on a workbook
How do you group a selection of styles on a workbook?
How to autoformat in Excel 2007
How to autoformat in excel 2007
Related articles
How To Use The Cell Styles Functionality In Excel 2010
When a request for a simple output of data is made, often data teams do not have time to make the data look particularly presentable as it was time consuming. They also do not always realise the importance of making data presentable as well as correct. Excel 2010 makes it very easy to create presentable data without having to manually highlight and format all the cells. This article shows you how.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
