radrss

Your Favorite Blogs In One Place

Viewing post at Freelanceswitch

How to Use Cell Styles in Excel in 60 Seconds

Advertisementby Andrew Childress27 Sep 2017Difficulty:BeginnerLength:ShortLanguages:EnglishEspañolPусскийTiếng Việt

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.

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:

• Microsoft Excel How to Protect Cells, Sheets, and Workbooks in Excel Andrew Childress
• Microsoft Excel How to Insert, Delete & Hide New Sheets in Excel in 60 Seconds Andrew Childress
• Microsoft Excel How to Freeze Panes and Rows in Excel in 60 Seconds Andrew Childress

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

Advertisement I'm Andrew Childress, a photographer, writer and entrepreneur from the southeast. I've always loved people photography because they're impossible to reproduce exactly.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.AdvertisementTranslations

Envato Tuts+ tutorials are translated into other languages by our community members—you can be involved too!

Translate this postPowered byAdvertisementSubscribe to Access