GCFLearnFree.org

This class helped me get a promotion at work. I would recommend it to anyone!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Formatting Cells

Excel 2013

Single page view print copy

Formatting Cells

Cell styles

Rather than formatting cells manually, you can use Excel's predesigned cell styles. Cell styles are a quick way to include professional formatting for different parts of your workbook, such as titles and headers.

To apply a cell style:

In our example, we'll apply a new cell style to our existing title and header cells.

  1. Select the cell(s) you wish to modify.
    Screenshot of Excel 2013Selecting a cell range
  2. Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu. In our example, we'll choose Accent 1.
    Screenshot of Excel 2013Choosing a cell style
  3. The selected cell style will appear.
    Screenshot of Excel 2013The new cell style

Applying a cell style will replace any existing cell formatting except for text alignment. You may not want to use cell styles if you've already added a lot of formatting to your workbook.

previous next
previous 1 2 3 4 5 6 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.