Microsoft office Excel lesson 9

To add a fill color

1. Select the cell(s) you wish to modify.
2. Click the drop-down arrow next to the Fill Color command on the Home tab. The Fill Color menu will appear.
3. Select the fill color you want to use. A live preview of the new fill color will appear as you hover the mouse over different options. In our example, we’ll choose Light Green.
4. The selected fill color will appear in the selected 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
1. Select the cell(s) you wish to modify.
2. Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu.
3. The selected cell style will appear.
TIP: 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.

Formatting text and numbers

One of the most powerful tools in Excel is the ability to apply specific formatting for text and numbers. Instead of displaying all cell content in exactly the same way, you can use formatting to change the appearance of dates, times, decimals, percentages (%), currency ($), and much more.

To apply number formatting
1. Select the cells(s) you wish to modify.
2. Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.
3. Select the desired formatting option.
4. The selected cells will change to the new formatting style.

Challenge!

1. Open an existing Excel 2013 workbook.
2. Select a cell and change the font style, size, and color of the text.
3. Apply bold, italics, or underline to a cell.
4. Try changing the vertical and horizontal text alignment for some cells.
5. Add a border to a cell range.
6. Change the fill color of a cell range.
7. Try changing the formatting of a number.