Four great Excel Cell Styles that will light your way

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel provides some handy pre-selected styles that you can apply to your cells. Here’s a selection of styles that we use, improve from Microsoft’s bland defaults and will light up your worksheets.

These are excellent for distinguishing headers from data, classifying data, or showing the function of each cell (calculations, output, notes, etc.)  Cell Styles are right there on the Home tab.

There’s a big grid of choices at Home | Cell Styles.

four great excel cell styles that will light your way microsoft excel 30190 - Four great Excel Cell Styles that will light your way

This article we’ll pick out the commonly used cell styles; Total, Note, Warning Text and Check Cell.

Like all Office styles, there’s the risk that documents look the same because most people use the defaults. We’ll suggest a few changes to make them stand out more.

Total

A quick way to style a total or grand total using one of the SUM() functions.

four great excel cell styles that will light your way microsoft excel 30197 - Four great Excel Cell Styles that will light your way

Note

When a cell comment isn’t enough.

four great excel cell styles that will light your way microsoft excel 30198 - Four great Excel Cell Styles that will light your way

We like changing this style to italics as well.

Warning Text

A useful quick style.  If the default isn’t prominent enough, right click on the Style, choose ‘Modify …’ then change the settings.

four great excel cell styles that will light your way microsoft excel 30199 - Four great Excel Cell Styles that will light your way

This is a larger font size than the default and Bold text.

Check Cell

A style to ‘check cell’ is a great idea but the default formatting doesn’t really scream “I need help!”

four great excel cell styles that will light your way microsoft excel 30194 - Four great Excel Cell Styles that will light your way

Change the Fill Effect (Modify Style | Format | Fill | Fill Effects to a two-color gradient.

four great excel cell styles that will light your way microsoft excel 30195 - Four great Excel Cell Styles that will light your way

A red gradient background with different border should catch the eye.

four great excel cell styles that will light your way microsoft excel 30196 - Four great Excel Cell Styles that will light your way

Modify styles

Change one of Microsoft’s inbuilt styles by right-clicking then choosing Modify.

four great excel cell styles that will light your way microsoft excel 30209 - Four great Excel Cell Styles that will light your way

subs profile e1563205311409 - Four great Excel Cell Styles that will light your way
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address