• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 4. Formatting Worksheet Data > Creating and Applying a Formatting Style

Creating and Applying a Formatting Style

Apply any specific cell formatting that you want the style to use in your worksheet (here, Arial, Bold, 12 pt, White text, Red fill color).

With the cell that contains the desired formatting selected, open the Format menu and choose Style to open the Style dialog box.

Type a descriptive name for the new style in the Style name field (for example, Sales Header) and click OK.

Select the cell(s) to which you want to apply your newly created style.

INTRODUCTION

Instead of assigning your data an existing Excel style (for example, Normal, Currency, Percent, and so forth), you can create your own style and apply it to cells. You begin by applying the specific formatting (for example, font, font style, font size, font color, and cell color) that you want the style to have, and then give the style a specific name.


TIP

Saving the style

The next time you exit Excel, you will be notified that you made a change to your global template and asked if you want to save the changes. If you want to keep the style you just created, click the Yes button; otherwise, click the No button.


Open the Format menu and choose Style to open the Style dialog box.

Click the down arrow next to the Style name field and select the style you just created from the list that appears.

Click OK.

The style is applied to the cells you selected.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint