2. Objectives. Change column width and row height.Position text within a cell by wrapping, rotating, indenting, and aligning.Change the appearance of cells using fonts, styles, colors, and borders.. 3. Objectives (cont.). Designate the format of a cell to accommodate different kinds of text and n
1. 1 INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet
2. 2 Objectives Change column width and row height.
Position text within a cell by wrapping, rotating, indenting, and aligning.
Change the appearance of cells using fonts, styles, colors, and borders.
3. 3 Objectives (cont.) Designate the format of a cell to accommodate different kinds of text and numerical data.
Apply and paint formats.
Create and use styles.
Find and replace cell formats.
4. 4 Terms Used in This Lesson AutoFormat
5. 5 When a Cell Is Too Small When a cell is too small, Excel
Displays a series of number signs (######).
Cuts off the data.
Lets the data run outside of the column.
Converts the data to a different numerical form (e.g., exponential form).
6. 6 Change Column Width and Row Height To change the width or height, place the mouse pointer on the right edge of a column or top of a row. The pointer will change to a double-headed arrow.
Widen a column or row by dragging the double-headed arrow.
7. 7 Position Text Within a Cell Text may be positioned by Wrapping Rotating Indenting Justifying Centering Merging