Formatting • Is applied to spreadsheet components for the purpose of organizing and clarifying information • When data is presented in a uniform and consistent format, it is much easier to understand. • Can be applied to any part of the spreadsheet.
Header/Footer • 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 Spreadsheet Formatting
Font Size and Style • Used to clarify information by adding emphasis to titles, column headings, and grand totals, etc. • Can also change font type and color Very Important!! Not as important.
Font Size and Style On the Main Menu toolbar, click Format\Cells, and then click the Font tab or use the icons on the Formatting Toolbar
Justification • Used to format cell data for the purpose of clarifying and organizing information • Can be applied globally, to the entire document OR to individual columns, rows, or cells. • 4 kinds of justification • Left – cells categorized as labels • Right – cells categorized as values • Center – formatting for titles or columns headings • Indent – format to emphasize subcategories • Example: (itemized list of expenses in a budget)
Justification Examples • Left Aligned • Column heading • Items • Right Aligned • Quantity • Decimal (prices) • Center • Table title
Adjusting Size of Cells, Columns, and Rows • Wrap- applied to cells that require more space when the row or column size is adjusted • Automatically – Go to Format, Cells, Alignment. Then under Text control, select the Wrap text check box, and then click OK. • Enter line break - To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER.
Adjusting Size of Cells, Columns, and Rows • Merge – used to combine adjacent cell ranges or cells • Center is the default alignment when cells are merged. Step 1 Step 2 Step 3 – Click the Merge and Center button on the toolbar. Step 4
Adjusting Size of Cells, Columns, and Rows • Column Width • In order to adjust the column width to fit the largest item in the column, double click on the border between the 2 column headings (ie. A & B) • When the ##### symbols appear, this indicates that the width is too small to display the contents.
Borders - Used to emphasize and organize information and can be applied to columns, rows, cell ranges, or individual cells. • On the Main Menu toolbar, click Format\Cells, and then click the Borders tab. • To apply a different border line style, click the arrow next to Line Style, and then click a line style on the palette.
Shading - Used to emphasize and organize information and can be applied to columns, rows, cell ranges, or individual cells. • Select the cells in which you want to apply shading (or remove shading). • To apply color, click the arrow next to Fill Color, and then click a color on the Palette. Fill Color Palette
Editing • Columns and Rows can be • Inserted • Go to Insert, Rows/Columns • Copied • Go to Edit, Copy • Pasted • Go to Edit, Paste • Deleted • Go to Edit, Delete Ctrl + C Ctrl + V Ctrl + X
Organizing tips… • Name your document something descriptive • Rename your worksheet tabs • Organize your worksheet tabs in to an order that makes sense. Label Label Label