How to Use Cell Styles in Excel in 60 Seconds PDF Print E-mail
Wednesday, 27 September 2017 08:55

Excel spreadsheets are perfect for storing data, but they can look a bit drab and boring without styling. That's why I'll teach you to use cell styles in Excel in this tutorial. 

How to Quickly Use Cell Styles in Excel 

 

Note: Watch this short tutorial screencast or follow the quick steps below, that compliment this video.

1. Choose From the Multiple Cell Styles in Excel

With the cell selected, I'll go ahead and click on the Styles drop-down and you can check out the many styles that are built into Excel.

Multiple Cell Styles in Excel
Excel cell style options.

2. Apply an Excel Header Style Option

One of the first ones I want to show you are the Heading Styles. For a cell that's a header or the top of a column, these are great styles. I'll click on one to apply it to a cell. You can see that these styles are divided by purpose too.

Excel Header Style
Excel Header Style (applied top-right).

3. Apply Excel Styles to Your Calculations

If you want to keep track of which cells are formulas versus static data, you could apply this Calculation Style as I'm doing here. I can also apply one of these styles to multiple cells at the same time. Watch here as I highlight all of the cells that I want to apply a single style to and then choose from the drop-down menu again. As I choose it, it applies it to all of the selected cells.

Excel Calculation Styles
Excel Calculation Styles (applied to Earnings data).

Finishing Up!

Combine these different styles to help your spreadsheet improve and make it more readable. If you're like me and don't know what to do to make your spreadsheets look better, these self styles are a great way to get started cleaning up your Excel sheets.

More Great Excel Tutorials on Envato Tuts+ 

Find comprehensive Excel tutorials on Envato Tuts+ to help you learn how to work with your data better in your spreadhsheets. We also have a quick-start in 60 seconds Excel video series to learn more Excel tools fast. 

Here are a few Excel tutorials to jump into to now: 

Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you'll make.

Read more: Envato Tuts+ Business