Spreadsheet Formatting

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