1 / 9

Spreadsheet Formatting

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

umed
Download Presentation

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 • Formattingapplied to spreadsheet for the purpose of organizing and clarifyinginformation. • Data presented in a uniform and consistentformat • Easier to understand than data presented with random formats. • 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. Types of Justification • Left Justification • Applied to cells formatted as Labels. • Indent • Applied to cell data to emphasize subcategories • Itemized list of expenses in a budget • Right Justification • Applied to cell formatted as Values. • Values should be formatted uniformly • Values can be formatted for a set number of decimal places with or without a comma separator • Center • Applied to titles and column headings

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

  6. 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.

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

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

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

More Related