Formatting Text

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Introduction

Formatting TextOnce you have entered information into a spreadsheet, you will need to be able to format it. In this lesson, you will learn how to use the bold, italic, and underline commands; modify the font style, size, and color; and apply borders and fill colors.

Formatting cells

To format text in bold or italics:

Formatting Commands

You can select entire columns and rows, or specific cells. To select the entire column, just left-click the column heading, and the entire column will appear as selected. To select specific cells, just left-click a cell and drag your mouse to select the other cells, then release the mouse button.

To format text as underlined:

Underline Command

To change the font style:

Font Style

As you move over the font list, the Live Preview feature previews the font for you in the spreadsheet.

To change the font size:

Font Size

To change the text color:

Text Colors


OR

To add a border:

Borders

You can change the line style and color of the border.

To add a fill color:

Fill Color


OR

You can use the fill color feature to format columns and rows and format a worksheet so it's easier to read.

To format numbers and dates:

Number Format

By default, the numbers appear in the General category, which means there is no special formatting.

In the Number group, you have some other options. For example, you can change the U.S. dollar sign to another currency format, switch numbers to percents, add commas, and change the decimal location.

Challenge!

Use the Budget workbook or any Excel workbook you choose to complete this challenge.