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.
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.
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.
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.