Excel Lecture 6

Changing Text Attributes with Toolbar Buttons

1.      Select the cell or range that contains the text whose look you want to change.

2.      To change the font, click the Font drop-down list, and select a new font name. To change the font size, click the Font Size drop-down list and select the size you want to use. You can also type the point size into the Font Size box and then press Enter.

3.      To add an attribute such as bold, italic, or underlining to the selected cells, click the appropriate button: Bold, Italic, or Underline, respectively.

You can also change the color of the font in a cell or cells. Select the cell or cells and click the Font Color drop-down arrow on the Formatting toolbar. Select a font color from the Color palette that appears.

Aligning Text in Cells

1.      Select the cell or range you want to align.

2.      Select the Format menu and then select Cells. The Format Cells dialog box appears.

3.      Click the Alignment tab.

4.      Choose from the following options to set the alignment:

o        Horizontal— Lets you specify a left/right alignment in the cells. (The Center Across selection centers a title or other text within a range of cells, which is discussed in a moment.)

o        Vertical— Lets you specify how you want the text aligned in relation to the top and bottom of the cells.

o        Orientation— Lets you flip the text sideways or print it from top to bottom instead of left to right.

o        Wrap Text— Tells Excel to wrap long lines of text within a cell without changing the width of the cell. (Normally, Excel displays all text in a cell on one line.)

o        Shrink to Fit— Shrinks the text to fit within the cell’s current width. If the cell’s width is adjusted, the text increases or decreases in size accordingly.

o        Merge Cells— Combines several cells into a single cell. All data is overlaid, except for the cell in the upper-left corner of the selected cells.

5.      Click OK when you have finished making your selections.

Aligning Text from the Toolbar

	Name	Description
	Align Left	Places data at left edge of cell
	Align Right	Places data at right edge of cell
	Center	Centers data in cell
	Merge and Center	Centers data in selected cell range

 

You can also align text by merging cells together. You do this by applying the following steps:

1. Selecting the cell that contains the data you want to merge with other cells.
2. Drag through the other cells that will become a part of the merge.
3. Click the Merge and Center button on the toolbar.

Adding Borders to Cells

1.      Select the cell(s) around which you want a border to appear.

2.      Open the Format menu and choose Cells. The Format Cells dialog box appears.

3.      Click the Border tab to see the Border options.

4.      Select the desired position, style (thickness), and color for the border. The position of the border is selected using the buttons along the left of the Border box. You can also click inside the Border box itself to place the border.

5.      Click OK or press Enter.

Add Borders from the Toolbar . You can use the Borders button on the Formatting toolbar to add a border to cells or cell ranges. Select the cells, and then click the Borders drop-down arrow on the Formatting toolbar to select a border type.

 

Advertisement