Download
introductory microsoft excel lesson 2 changing the appearance of a worksheet n.
Skip this Video
Loading SlideShow in 5 Seconds..
INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet PowerPoint Presentation
Download Presentation
INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet

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

76 Vues Download Presentation
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.