1 / 18

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

INTRODUCTORY MICROSOFT EXCEL Lesson 2 – Changing the Appearance of a Worksheet. 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.

trella
Télécharger la présentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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.

More Related