Formats xp xp goal of highlighting provide strong

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: osoft Excel 2010 37 XP Selecting Table Style OptionsXP New Perspectives on Microsoft Excel 2010 38 Highlighting Cells with Conditional Formats • • • • XP XP Goal of highlighting: Provide strong visual clue of important data or results Format applied to a cell depends upon value or content of the cell Dynamic: If cell’s value changes, cell’s format also changes as needed Excel has four conditional formats: data bars, highlighting, color scales, and icon sets New Perspectives on Microsoft Excel 2010 39 Highlighting Rules • XP XP Each conditional format has a set of rules that define how formatting should be applied and under what conditions format will be changed New Perspectives on Microsoft Excel 2010 40 Highlighting Cells with Conditional Formats New Perspectives on Microsoft Excel 2010 XP XP 41 Highlighting Cells with Conditional Formats • XP XP Always include a legend – a key that shows each color used in the worksheet and what it means New Perspectives on Microsoft Excel 2010 42 Hiding Worksheet Data • • • • XP XP Manage contents of a large worksheet by selectively hiding rows and columns of extraneous data Allows you to focus attention on only a select few data points Does not affect other formulas in workbook Never hide data that is crucial to understanding a workbook New Perspectives on Microsoft Excel 2010 43 Formatting the Worksheet for Printing • • XP XP Print options can be applied to an entire workbook or to individual sheets Look at a worksheet in Page Layout view to see how it would print New Perspectives on Microsoft Excel 2010 44 Formatting the Worksheet for Printing the print area allows you to Defining XP XP • override default settings and print part of a worksheet – Region sent to the printer from the active sheet – Can cover adjacent or nonadjacent range in current worksheet – Generally easiest to set in Page Break Preview • Fit a large worksheet on a single page by New Perspectives on Microsoft Excelthe page margin reducing size of 2010 45 Formatting the Worksheet for Printing • XP XP Inserting page breaks – – Automatic page breaks Manual page breaks New Perspectives on Microsoft Excel 2010 46 Formatting the Worksheet for Printing • XP XP Add print titles (descriptive information) on each page of a printout in case pages become separated New Perspectives on Microsoft Excel 2010 47 Formatting the Worksheet for Printing • • • XP XP Create page headers and footers to include text not usually found within the worksheet (e.g., author, date, filename) Headers and footers have three sections: left, center, right Elements are dynamic New Perspectives on Microsoft Excel 2010 48...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online