Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )

Applying Cell Styles

Cell Styles are a combination of fill and font color designed to highlight or emphasize cell contents. They are easily applied to your workbook.

1.      Select the cell(s) whose style you want to change

2.      From the Home command tab, in the Styles group, click CELL STYLES
A pull-down list appears.
NOTE: When you hover your mouse over different styles, a preview of the style will appear in the selected cells.

3. From the Good, Bad and Neutral; Data and Model; or Titles and Headings group, select the desired cell style
   The style is applied to the selected cells.

Formatting Borders

To make certain cells stand out in the worksheet, you may want to format a cell's borders.

Changing Borders

1.      Select the cell(s) whose borders you want to format

2.      From the Home command tab, in the Font group, click thenext to BORDER» select the desired border
The border is applied.

Changing Border Color

1.      From the Home command tab, in the Font group, click thenext to BORDER» select Line Color » select the desired color
The cursor changes to the shape of a pencil.

2.      To format individual borders, click the borders you want changed
To format multiple cells, click and drag across the desired cells

3.      To quit formatting border colors, press [Esc]

 

Changing Border Style

1.      From the Home command tab, in the Font group, click thenext to BORDER» select Line Style » select the desired line style

2.      To format individual borders, click the borders you want changed
To format multiple cells, click and drag across the desired cells

3.      To quit formatting border styles, press [Esc]

Deleting Borders

1.      From the Home command tab, in the Font group, click thenext to BORDER» select Erase Border
The cursor changes to the shape of an eraser.

2.      To delete individual borders, click the borders you want changed
To delete multiple cell borders, click and drag across the desired cells

3.      To quit deleting borders, press [Esc]

Using Conditional Formatting

Conditional Formatting allows you to format cells depending on how their data relates to other data. For example, in a list of numbers ranging from 1 to 10, you can format cells with data closer to 1 to have red fill color, and cells with numbers closer to 10 to have green fill color. You can also format data bars to appear within the cell, making a concise bar graph within a worksheet. For more information, refer to Working with Conditional Formatting.

Merging Cells

A cell merge converts selected cells into a single cell. This can be useful for creating titles.

Creating a Cell Merge 

WARNING: After a cell merge, if two or more selected cells have data in them, Excel will display the information from the cell closest to the upper left corner, deleting all other data.

1.      Select the cells you want to merge

2. From the Home command tab, in the Alignment group, click MERGE & CENTER
   The cells are merged and the text aligns to the center

Customizing a Cell Merge

1.      Select the cells you want to merge

2.      Click thenext to MERGE & CENTER
A pull-down list appears.

3.      To merge cells and align text to the center, click MERGE & CENTER
To merge cells only as rows (i.e., columns do not merge), click MERGE ACROSS
To merge cells without setting an alignment, click MERGE CELLS

Removing a Cell Merge

1.      Select the cell you want to unmerge

2.      Click thenext to MERGE & CENTER » select Unmerge Cells
The cell merge is removed.

 

1.      The cell merge is removed.

Wrapping Text

If you have text that appears in a single cell and you want to increase the height of the cell without expanding the row or column, you can use the Wrap text option.

1.      Select the appropriate cells

2.      From the Home command tab, in the Alignment group, click WRAP TEXT
The text wrap is applied.
NOTE: To remove the text wrap, click WRAP TEXT again.

Copying Cell Formatting

If you want to copy only a cell's formatting you can use the Painter option. This will format the destination cell the same as the source cell without changing its content. For more information, refer to Formatting with the Painter.

Clearing Cell Formatting

You can remove all cell formatting while preserving text formatting in selected cells (e.g., fill color, alignment, and borders will be cleared, but text color, font size, and font face will not be cleared).

1.      Select the cell(s) containing the formatting to be cleared

2.      From the Home command tab, in the Editing group, click CLEAR» select Clear Formats
The cell formatting is removed.

Related Posts by Categories