On microsoft excel 2010 new perspectives 24 options

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: ides more choices • Six tabs, each focusing on different options: – Number – Alignment – Font – Border – Fill on Microsoft Excel 2010 New Perspectives • 24 Options in the Format Cells Dialog Box • XP XP Border tab New Perspectives on Microsoft Excel 2010 25 XP X Copying and Pasting Formats P • Copying formats with Format Painter – Fast and efficient way of maintaining a consistent look and feel throughout a workbook – Copies formatting without duplicating data New Perspectives on Microsoft Excel 2010 26 XP X Copying and Pasting Formats P • Use Paste Options Button to paste formatting from a copied range along with its contents New Perspectives on Microsoft Excel 2010 27 XP X Copying and Pasting Formats P • Use Paste Special to control exactly how to paste the copied range New Perspectives on Microsoft Excel 2010 28 Visual Overview New Perspectives on Microsoft Excel 2010 XP XP 29 Table Styles and Page Formatting New Perspectives on Microsoft Excel 2010 XP XP 30 Applying Cell Styles • • XP XP Use styles to ensure that cells displaying same type of data use the same format Style – Selection of formatting options using a specific font and color from the current theme – If style is later revised, appearance of any cell formatted with that style is updated automatically; saves time and effort New Perspectives on Microsoft Excel 2010 31 Applying Cell Styles New Perspectives on Microsoft Excel 2010 XP XP 32 Working with Themes • • • XP XP Appearance of fonts, colors, and cell styles depends on workbook’s current theme If theme is changed, formatting of fonts, colors, and cell styles changes throughout entire workbook Only elements directly tied to a theme change when you select a different theme New Perspectives on Microsoft Excel 2010 33 Working with Themes New Perspectives on Microsoft Excel 2010 XP XP 34 Creating Formulas to Add and Subtract Values • XP XP Use this data to identify trends New Perspectives on Microsoft Excel 2010 35 Working with Table Styles • • • XP XP Specifies formats (e.g., font color, fill color) for each element More efficient than formatting individual cells Ensures that table’s formatting reflects any changes made to the table New Perspectives on Microsoft Excel 2010 36 Working with Table Styles • XP XP Table style elements can be turned on or off – Header Row – Total Row – First Column – Last Column – Banded Rows – Banded Columns New Perspectives on Micr...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online