1 / 13

Format a Workbook

Format a Workbook . Lesson 2 – Microsoft Excel 2010. Formatting is changing the way that something looks . Proper formatting should enhance the readability and presentation of data . Formatting: What is it and Why?.

rhona
Download Presentation

Format a Workbook

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. Format a Workbook Lesson 2 – Microsoft Excel 2010

  2. Formatting is changing the way that something looks. • Proper formatting should enhance the readability and presentation of data. Formatting: What is it and Why?

  3. Font – A set of printable or displayable text characters in a specific style and size. • FontStyle – Bold, italics, underlined, etc… • Font Size – in points • For example: • Font: Arial Bold 12 point • Font Size: 12 point • Font Style: Bold Formatting Text

  4. c Use the Font group on the Home ribbon to change the font, font size, and font style. Use the Alignment group on the Home ribbon to change the alignment of and indent text. Formatting Text, continued.

  5. Text can be vertically and/or horizontally aligned, each by left, center, or right alignment. Example Vertically: Centered and then Horizontally Centered. Formatting Text, continued.

  6. Numeric data is any number that will be used in calculations. • Formatting a numeric entry as text allows the entry to be treated as text even when a number is present in the cell. Formatting Numeric Data

  7. Applying comma style inserts commas between groups of thousands. Use the increase/decrease decimal buttons to add or remove decimal places. (Decimal places can be used in numbers other than currency. By default, numbers use the “General” format. Applying currency style applies a dollar sign, commas, and two decimal places. Applying percent style multiples the number by 100 and adds a percent symbol. Formatting Numeric Data, Cont.

  8. The Format Painter will copy a format from one area to another without altering the data. • It will copy the font, font size, font style, font color, alignment, indentation, number format, border, and shading. HOW TO: Select an object with the formatting you want, click the format painter, click or select the new object that you want to apply the formatting to. Using Format Painter

  9. Borders will emphasize a specific portion of a worksheet by applying various styles and colors of lines around a range of data. Adding Borders to Cells

  10. Applying shading and patterns to a cell or range of cells can draw attention to the area. • Shading is also a good method for improving readability of cells. Adding Shading to Cells

  11. The Cell Styles Command • will apply predefined formats to a range of cells. • will serve as a time saver in worksheet creation. • will automatically apply borders, shading, patterns, and font changes to a range of cells. Using Cell Styles

  12. Styles: • are a defined set of formats that can be applied to cells or a range of cells. • can be defined by the user and that they facilitate consistency in worksheet formats. Creating and Applying Styles

  13. Merging cells will convert multiple cells into one individual cell. • Merging cells allows for ease of formatting within the cells. Merging Cells Select the cells and click “merge and center” in the Alignment group on the Home tab or on the Alignment tab in the Format Cells Dialog box.

More Related