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.
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:
- Microsoft ExcelHow to Protect Cells, Sheets, and Workbooks in ExcelAndrew Childress
- Microsoft ExcelHow to Insert, Delete & Hide New Sheets in Excel in 60 SecondsAndrew Childress
- Microsoft ExcelHow to Freeze Panes and Rows in Excel in 60 SecondsAndrew Childress
Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you'll make.
Subscribe below and we’ll send you a weekly email summary of all new Business tutorials. Never miss out on learning about the next big thing.Update me weekly
Envato Tuts+ tutorials are translated into other languages by our community members—you can be involved too!Translate this post