Teach Yourself VISUALLY Excel® 2010

Table of Contents

Chapter 1: Working with Excel
Getting to Know Excel
Build a Spreadsheet
Manipulate Data
Start Excel
Tour the Excel Window
Work with Excel’s Ribbon
Work with Excel’s Galleries
Customize the Quick Access Toolbar
Customize the Ribbon
Work with Smart Tags
Change the View
Configure Excel Options
Add Excel to the Windows 7 Taskbar
Quit Excel
Chapter 2: Entering and Editing Excel Data
Learning the Layout of a Worksheet
Understanding the Types of Data You Can Use
Enter Text into a Cell
Enter a Number into a Cell
Enter a Date or Time into a Cell
Insert a Symbol
Edit Cell Data
Delete Data from a Cell
Chapter 3: Working with Excel Ranges
Select a Range
Fill a Range with the Same Data
Fill a Range with a Series of Values
Move or Copy a Range
Insert a Row or Column
Insert a Cell or Range
Delete Data from a Range
Delete a Range
Hide a Row or Column
Freeze Rows or Columns
Merge Two or More Cells
Transpose Rows and Columns
Chapter 4: Working with Range Names
Understanding the Benefits of Using Range Names
Define a Range Name
Use Worksheet Text to Define a Range Name
Navigate a Workbook Using Range Names
Change a Range Name
Delete a Range Name
Paste a List of Range Names
Chapter 5: Formatting Excel Ranges
Change the Font and Font Size
Apply Font Effects
Change the Font Color
Align Text Within a Cell
Center Text Across Multiple Columns
Rotate Text Within a Cell
Add a Background Color to a Range
Apply a Number Format
Change the Number of Decimal Places Displayed
Apply an AutoFormat to a Range
Apply a Conditional Format to a Range
Apply a Style to a Range
Change the Column Width
Change the Row Height
Wrap Text Within a Cell
Add Borders to a Range
Copy Formatting from One Cell to Another
Chapter 6: Building Formulas and Functions
Understanding Excel Formulas
Build a Formula
Understanding Excel Functions
Add a Function to a Formula
Add a Row or Column of Numbers
Build an AutoSum Formula
Add a Range Name to a Formula
Reference Another Worksheet Range in a Formula
Move or Copy a Formula
Switch to Absolute Cell References
Toggle the Formula Bar On and Off
Troubleshoot Formula Errors
Chapter 7: Manipulating Excel Worksheets
Navigate a Worksheet
Rename a Worksheet
Create a New Worksheet
Move a Worksheet
Copy a Worksheet
Delete a Worksheet
Change the Gridline Color
Toggle Worksheet Gridlines On and Off
Toggle Worksheet Headings On and Off
Set the Worksheet Tab Color
Set the Worksheet Background
Zoom In On or Out of a Worksheet
Split a Worksheet into Two Panes
Hide and Unhide a Worksheet
Chapter 8: Dealing with Excel Workbooks
Create a New Blank Workbook
Create a New Workbook from a Template
Save a Workbook
Open a Workbook
Arrange Workbook Windows
Find Text in a Workbook
Replace Text in a Workbook
Check Spelling and Grammar
Close a Workbook
Chapter 9: Formatting Excel Workbooks
Modify the Workbook Colors
Set the Workbook Fonts
Choose Workbook Effects
Apply a Workbook Theme
Add a Workbook Header
Add a Workbook Footer
Chapter 10: Printing Excel Workbooks
Adjust the Workbook Margins
Change the Page Orientation
Insert a Page Break
Choose a Paper Size
Set the Print Area
Configure Titles to Print on Each Page
Preview the Printout
Print a Workbook
Chapter 11: Analyzing Excel Data
Sort a Range
Filter a Range
Set Data Validation Rules
Convert a Range to a Table
Create a Data Table
Summarize Data with Subtotals
Group Related Data
Analyze Data with Goal Seek
Analyze Data with Scenarios
Create a PivotTable
Load Excel’s Analysis ToolPak
Chapter 12: Visualizing Data with Excel Charts
Examining Chart Elements
Understanding Chart Types
Create a Chart
Add Chart Titles
Add Data Labels
Position the Chart Legend
Display Chart Gridlines
Display a Data Table
Change the Chart Layout and Style
Select a Different Chart Type
Change the Chart Source Data
Move or Resize a Chart
Add a Sparkline to a Cell
Chapter 13: Formatting Excel Charts
Format Chart Elements
Customize a Chart Element Background
Set a Chart Element’s Outline
Add Effects to a Chart Element
Apply a Style to a Chart Element
Apply a WordArt Style to Chart Text
Chapter 14: Adding and Editing Worksheet Graphics
Draw a Shape
Insert a Clip Art Image
Insert a Photo
Insert a WordArt Image
Insert a SmartArt Graphic
Move or Resize a Graphic
Crop a Picture
Format a Picture
Add a Shadow or Glow to a Picture
Add a Reflection or 3-D Effect to a Picture
Add an Artistic Effect to a Photo
Recolor an Image
Chapter 15: Collaborating with Other People
Add a Comment to a Cell
Protect a Worksheet’s Data
Protect a Workbook’s Structure and Windows
Share a Workbook with Other Users
Track Workbook Changes
Accept or Reject Workbook Changes
Send a Workbook as an E-Mail Attachment
Save Excel Data as a Web Page
Make a Workbook Compatible with Earlier Versions of Excel
Collaborate on a Workbook Online

Teach Yourself VISUALLY™ Excel® 2010

Trademark Acknowledgments


Contact Us



Executive Editor

Jody Lefevere

Project Editor

Lynn Northrup

Technical Editor

Namir Shammas

Editorial Director

Robyn Siesky

Business Manager

Amy Knies

Senior Marketing Manager

Sandy Smith

Vice President and Executive Group Publisher

Richard Swadley

Vice President and Executive Publisher

Barry Pruett

Project Coordinator

Patrick Redmond

Graphics and Production Specialists

Andrea HornbergerJennifer MayberryMark Pinto

Quality Control Technician

Lauren Mandelbaum


Melissa D. Buddendeck


Potomac Indexing, LLC

Screen Artist

Jill A. Proll


Cheryl Grubbs

About the Author

Paul McFedries is is a technical writer who has been authoring computer books since 1991. He has more than 60 books to his credit, which together have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Microsoft Office 2008 for Mac, Excel 2010 Visual Quick Tips, and Excel 2010 PivotTable and PivotCharts Visual Blueprint. Paul also runs Word Spy, a Web site dedicated to tracking new words and phrases (see Please visit Paul’s personal Web site at

Author’s Acknowledgments

The book you hold in your hands is not only an excellent learning tool, but it is truly beautiful, as well. I am happy to have supplied the text that you will read, but the gorgeous images come from Wiley’s crack team of artists and illustrators. The layout of the tasks, the accuracy of the spelling and grammar, and the veracity of the information are all the result of hard work performed by project editor Lynn Northrup and technical editor Namir Shammas. Thanks to both of you for your excellent work. My thanks, as well, to executive editor Jody Lefevere for asking me to write this book.

How to Use This Book

Who This Book Is For

This book is for the reader who has never used this particular technology or software application. It is also for readers who want to expand their knowledge.

The Conventions in This Book

001 Steps

This book uses a step-by-step format to guide you easily through each task. Numbered steps are actions you must do; bulleted steps clarify a point, step, or optional feature; and indented steps give you the result.

002 Notes

Notes give additional information — special conditions that may occur during an operation, a situation that you want to avoid, or a cross reference to a related area of the book.

003 Icons and Buttons

Icons and buttons show you exactly what you need to click to perform a step.

004 Tips

Tips offer additional information, including warnings and shortcuts.

005 Bold

Bold type shows command names, options, and text or numbers you must type.

006 Italics

Italic type introduces and defines a new term.