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

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

View Full Document Right Arrow Icon
COMPREHENSIVE Excel Tutorial 2 Formatting a  Workbook
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
Formatting Workbooks Formatting  is the process of changing a  workbook’s appearance by defining the fonts,  styles, colors, and decorative features 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 workbook’s  appearance before you apply them New Perspectives on Microsoft Office Excel 2007 4
Background image of page 4
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
Background image of page 5

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

View Full Document Right Arrow Icon
Working with Color Theme colors  are the 12 colors that belong  to the workbook’s 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
Background image of page 6
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
Background image of page 7

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

View Full Document Right Arrow Icon
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
Background image of page 8
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
Background image of page 9

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

View Full Document Right Arrow Icon
Formatting Data New Perspectives on Microsoft Office Excel 2007 10
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 40

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

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