Creating and sharing styles


show more Creating and sharing styles provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Creating and sharing styles

Sometimes you want to apply styles that don't exist as part of Excel's built-in style. So you can create your own. The easiest way to create your own style is to apply the formatting first just as though you're doing regular formatting and then use those cells as the example to define the style. What makes it so useful is that if you change some of the characteristics of the style like color, font, or fill or border, every cell that is tagged with that style will immediately change. So that keeps your formatting consistent and it also lets you format faster.

Well, let's take a look here. We are sorted by department. Let's select the Graphics department here. It doesn't have any formatting yet, and let's change the color. So click the Color dropdown, and I will choose a green here keeping with our Olive theme, and choose a color and I'll choose white, so we have a reverse look, and let's change the font face. Let's click that and keep in mind the fonts ...

Creating and sharing styles
Video duration: 5m 33s 6h 21m Beginner

Viewers:

Creating and sharing styles provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...