INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet

# INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet

Télécharger la présentation

## INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
##### Presentation Transcript

1. INTRODUCTORY MICROSOFT EXCELLesson 2 – Changing the Appearance of a Worksheet

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 numerical data. • Apply and paint formats. • Create and use styles. • Find and replace cell formats.

4. Terms Used in This Lesson • AutoFormat • Indented text • Rotated text • Style • Wrapped text

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. 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. Position Text Within a Cell • Text may be positioned by • Wrapping • Rotating • Indenting • Justifying • Centering • Merging

8. Designate the Format of a Cell • The format of a cell may be changed by using different • Fonts • Font sizes • Styles • Colors • Borders

9. Apply and Paint Formats • You may paint a format that exists in another area of the worksheet. • Select a cell with the desired format. • Click the Format Painter button. • Drag the cells that you want to apply the format to.

10. General Number Currency Accounting Date Time Percentage Fraction Scientific Text Designate the Format of a Cell • Cells may be formatted to accommodate different kinds of data.

11. Designate the Format of a Cell (cont.)

12. Create and Use Styles • A style is a combination of formatting characteristics such as alignment, font, border, or pattern. • You may apply a style that has already been created in Excel.

13. Clearing Cell Formats • Remove cell formats by selecting the cell or range, choosing Clear on the Edit menu, and then clicking Formats on the submenu.

14. AutoFormats • An AutoFormat is a collection of fonts, patterns, and alignments that can be applied to a range of data. • AutoFormats are applied by choosing the AutoFormat command on the Format menu.

15. Find and Replace Cell Formats • You may also find specific formats in a workbook and replace the format with another format. • For example, you may replace all italicized text with bolded text.

16. Summary • You can wrap, rotate, indent, or align the position of text within the cells. • Font, font size, and style (bolding, italicizing, and underlining) may be changed. Color and borders may also be added. • A cell may be changed to accommodate data in a variety of numerical formats.

17. Summary (cont.) • Formatting characteristics such as alignment, font, border, or pattern may be applied by using the Styles command. • Format painting copies the format of a worksheet cell without copying the contents of the cell.

18. Summary (cont.) • Various collections of fonts, patterns, and alignments can be applied to a range of data by using the AutoFormat command. • The Find and Replace command may be used to change cell formats.