Overview If you study this page, you'll be able to do the following.

Let's open the workbook you saved in the previous "Let's save and open a worksheet", and format some text.

Practice: How to open a workbook For information on how to open a workbook, refer to "Let's save and open a worksheet".

 Top of Page

• Types of text formatting

• Let's format some text

Types of text formatting

The text formatting is primarily found under Font on the Home tab of the Ribbon.

See the table below for the names and roles of the buttons displayed in the Ribbon. Let's combine them and try to format some text.

Button	Name	Role
	Font	Changes the font.
	Font Size	Changes the size of the text.
	Increase Font Size	Makes the text larger.
	Decrease Font Size	Makes the text smaller.
	Bold	Makes the selected text bold.
	Italic	Italicizes the selected text.
	Underline	Draws a line under the selected text.
	Bottom Border	Applies a border to the currently selected cell.
	Fill Color	Colors the background of selected cells.

Tip: A Ribbon button can be selected and not selected Among the buttons used for text formatting, there is the selected (Yellow: ) and the not selected (the same color as the Ribbon: ). You can switch between the two states by clicking the button. "Selected" means that the feature is applied. By the way, if you change the current position of the cursor, the state of the button for that location is reflected.

 Top of Page

Let's format some text

1. Open the workbook you saved previously, and select cell "A1".

   

   Practice: The selected cell is called the "active cell". The selected cell is the "active cell", and the "cell address" is the "You are Here" that indicates the cell's position.

2. Type in "Nikko Bus Tour Participant List", and then click the Enter key.

   

   Tip: What if the typed in text disappears!! If you type text in a cell that is not wide, the typed in text sometimes disappears. However, you can see the text by increasing the width of the cell. Position the cursor between column A and column B. When you do so, it turns into a cross. Double-click there. The text becomes visible. In Excel, double-clicking adjusts the cell to the appropriate width.

3. Select the word "Nikko".

   

   Tip: Change information in a cell When you select a cell that contains data, the content of the cell is displayed above. This is called the "Formula Bar". Let's remember that name because it shows up a lot from now on.

4. From Font, select Arial Black.

   

5. With the word "Nikko" selected, change the color of the text.

   

6. Select the two words "Bus Tour" in the Formula Bar.

   

7. Let's click Bold to select it and change the color.

   

8. The thickness of the text and its color change.

   

9. Select "Participant List" and then change the font and color. Refer to the example shown in the figure below.

   

In this way, let's try to combine various features to format text. This feature is basic. Practice until you learn it.

 Top of Page