Excel.02 - COMPREHENSIVE Excel Tutorial 2 Formatting a...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

Unformatted text preview: COMPREHENSIVE Excel Tutorial 2 Formatting a Workbook XP XP Objectives Format text, numbers, and dates Change font colors and fill colors Merge a range into a single cell Apply a built-in cell style Select a different theme New Perspectives on Microsoft Office Excel 2007 2 XP XP Objectives Apply a built-in table style Add conditional formats to tables with highlight rules and data bars Hide worksheet rows Insert print titles, set print areas, and insert page breaks Enter headers and footers New Perspectives on Microsoft Office Excel 2007 3 XP XP Formatting Workbooks Formatting is the process of changing a workbooks appearance by defining the fonts, styles, colors, and decorative features A theme is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook As you work, Live Preview shows the effects of formatting options on the workbooks appearance before you apply them New Perspectives on Microsoft Office Excel 2007 4 XP XP Formatting Text The appearance of text is determined by its typeface , which is the specific design used for the characters Font Serif fonts Sans serif fonts Theme font Non-theme font Font Style Font Size Measured in points New Perspectives on Microsoft Office Excel 2007 5 XP XP Working with Color Theme colors are the 12 colors that belong to the workbooks theme Standard and custom colors Apply a color by selecting a cell or range of cells, clicking the Font Color or Fill Color button arrow, and then selecting an appropriate color New Perspectives on Microsoft Office Excel 2007 6 XP XP Formatting Text Selections The Mini toolbar appears when you select text and contains buttons for commonly used text formats New Perspectives on Microsoft Office Excel 2007 7 XP XP Setting a Background Image You can use a picture or image as the background for all the cells in a worksheet Click the Page Layout tab on the Ribbon Click the Background button Locate the background, and then click the Insert button New Perspectives on Microsoft Office Excel 2007 8 XP XP Formatting Data By default, values appear in the General number format , which, for the most part, displays numbers exactly as you enter them The Number group on the Home tab has buttons for formatting the appearance of numbers Comma style button Decrease Decimal button Percent Style button Increase Decimal button Accounting Number Format button New Perspectives on Microsoft Office Excel 2007 9 XP XP Formatting Data New Perspectives on Microsoft Office Excel 2007 10 XP...
View Full Document

Page1 / 40

Excel.02 - COMPREHENSIVE Excel Tutorial 2 Formatting a...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online