O'Reilly logo

John Walkenbach's Favorite Excel 2010 Tips and Tricks by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1. Basic Excel Usage

In this part, you'll find tips and tricks covering some of the fundamental uses of Excel, from selecting cells and navigating sheets in a workbook to hiding rows and columns, as well as working with the Quick Access toolbar and changing Excel's color scheme.

Tips and Where to Find Them

  • Tip 1 Understanding Excel Versions 9

  • Tip 2 Maximizing Ribbon Efficiency 12

  • Tip 3 Understanding Protected View 15

  • Tip 4 Selecting Cells Efficiently 17

  • Tip 5 Making "Special" Range Selections 20

  • Tip 6 Undoing, Redoing, and Repeating 22

  • Tip 7 Discovering Some Useful Shortcut Keys 25

  • Tip 8 Navigating Sheets in a Workbook 26

  • Tip 9 Resetting the Used Area of a Worksheet 27

  • Tip 10 Understanding Workbooks versus Windows 28

  • Tip 11 Customizing the Quick Access Toolbar 30

  • Tip 12 Customizing the Ribbon 34

  • Tip 13 Accessing the Ribbon with Your Keyboard 37

  • Tip 14 Recovering Your Work 38

  • Tip 15 Customizing the Default Workbook 40

  • Tip 16 Using Document Themes 42

  • Tip 17 Hiding User Interface Elements 47

  • Tip 18 Hiding Columns or Rows 50

  • Tip 19 Hiding Cell Contents 52

  • Tip 20 Taking Pictures of Ranges 53

  • Tip 21 Performing Inexact Searches 55

  • Tip 22 Replacing Formatting 57

  • Tip 23 Changing the Excel Color Scheme 60

  • Tip 24 Limiting the Usable Area in a Worksheet 61

  • Tip 25 Using an Alternative to Cell Comments 64

  • Tip 26 Understanding the Excel Help System 65

  • Tip 27 Making a Worksheet "Very Hidden" 68

  • Tip 28 Working with the Backstage View 70

Understanding Excel Versions

If you're reading this book, you should be using Excel ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required