1 / 15

Spreadsheet Formatting

Spreadsheet Formatting. Formatting. Formatting is applied to spreadsheet components for the purpose of organizing and clarifying information. Data that is presented in a uniform and consistent format is much easier to understand than data presented with random formats.

speight
Télécharger la présentation

Spreadsheet Formatting

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. Spreadsheet Formatting

  2. Formatting • Formatting is applied to spreadsheet components for the purpose of organizing and clarifying information. • Data that is presented in a uniform and consistent format is much easier to understand than data presented with random formats. • Formatting can be applied to pages, columns, rows, cell ranges, and cells.

  3. A Header/Footer • Headers or Footers are used to add identifying information to a spreadsheet. • May include: • Title of company • Date • Page number • Time of creation or update • Contact information Footer Example

  4. Font Size and Style • Font Size and Font Style are used to clarify information by adding emphasis to titles, column headings, and grand totals, etc. • can also change font type and color Example: which title below is emphasized more? Title of Spreadsheet or Title of Spreadsheet

  5. Justification • Justification is also used to format cell data for the purpose of clarifying and organizing information • Left, Right, or Centerjustification can be applied globally to columns, rows, or cells. • Indent is used to emphasize subcategories • The Format Painter can also be used to apply global formats.

  6. Types of Justification • Left Justification – Left is the default justification for cells formatted as Labels. • Indent– Indent is a format applied to cell data to emphasize subcategories, such as the itemized list of expenses in a budget

  7. Types of Justification 3. RightJustification – Rightis the default justification for cells formatted as Values. • Values should be formatted uniformly, such as, using two decimal places for all like data, or using currency for total amounts Ex. $500 vs. $500.00 • Values can be formatted for a set number of decimal places with or without a comma separator. Ex. $1024.30 or $1,024.30

  8. [Right Justification (continued) ] • Values can be formatted in a variety of date formats Ex. October 30, 2009 30 Oct 2009 10/30/09 d. Other formats for Values include time, percentage, fraction, and scientific

  9. Types of Justification 4. Center– Centering is a format usually applied to titles and column headings

  10. Justification Examples Centering of the Table Title • Left Aligned (text) • Column heading • Listed Items • Right Aligned (values) • Quantity • Numbers with decimals (Prices)

  11. Adjusting Height, Width, and Size of Cells, Columns, and Rows • Wrap text is used to align multi-line text within a cell. • Mergeis used to combine two or more cells. • Center is the default alignment when cells are merged.

  12. Adjusting Height, Width, and Size of Cells, Columns, and Rows • Column Width • Column Width is adjusted to fit the longest entry. • Double click on the border between the 2 column heading • When the ##### symbols appear in a cell, this indicates that the width is too small to display the contents.

  13. Borders and Shading • are used to emphasize and organize information, and • can be applied to columns, rows, cell ranges, or individual cells These lines are Borders! • Reminder: select the columns, rows, or cells on which you want to apply Borders and Shading

  14. Editing • ColumnsandRowscan be • Inserted • Copied • Pasted • Deleted • Cell Data can be • Cleared • Copied • Pasted

  15. Renaming and Reordering • Renaming a spreadsheettabadds a descriptive identifier to the spreadsheet • The Reorderingof spreadsheet tabs is helpful in organizing and clarifyinginformation

More Related