1 / 18

INTRODUCTORY MICROSOFT EXCEL Lesson 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 n

yanka
Download Presentation

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. 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 Indented text Rotated text Style Wrapped text

    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

More Related