1 / 12

Spreadsheet formatting

Spreadsheet formatting. MITA . Formatting. Applied to spreadsheet components for the purpose of organizing and clarifying information Data in a uniform and consistent format is much easier to understand . Header/Footer. Used to identify information to a spreadsheet May include:

darci
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 MITA

  2. Formatting • Applied to spreadsheet components for the purpose of organizing and clarifying information • Data in a uniform and consistent format is much easier to understand

  3. Header/Footer • Used to identify information to a spreadsheet • May include: • Title of company • Date • Page number • Time of creation • Contact information

  4. Font Size and Style • Used to clarify information by adding emphasis to: • Titles • Column/Row headings • Grand totals

  5. Justification • Can be applied globally to columns or rows • Cell data titles, headings • Labels • Values • (formulas, functions, dates, times, and numbers)

  6. Justification = Consistency • Left (default) • Labels • Right • Values • Decimals – 200.00 • Commas – Use or Don’t Use • Dollars - $ • Dates - Consistent • Center • Titles and column/row headings • Indents • Subcategories • Itemized list of expenses in a budget

  7. Wrap • Applied to cells that require more space when the row or column size is adjusted • Multi-line text

  8. Merge • Used to combine adjacent cell ranges or cells • When merged the default alignment is centered

  9. Column Width • Adjusted to fix the longest entry • ### will appear in a cell if the width is too small to display the contents

  10. Borders and Shading • Emphasizes and organizes information • Can be applied to: • Columns • Rows • Cell ranges • Individual cells

  11. Editing • Columns and Rows can be: • Inserted, copied, pasted, or deleted • Cell data can be cleared, copied, or pasted • Cells can be merged when space requirements are an issue

  12. Renaming • Makes a spreadsheet more user-friendly by adding a descriptive identifier to the spreadsheet tab • Spreadsheets can also be reordered

More Related