O'Reilly logo

Microsoft® Office 2010 Inside Out by Ed Bott and Carl Siechert

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 14. Excel 2010 Inside Out

Customizing the Worksheet View

Advanced Worksheet Formatting

Finding, Editing, Moving, and Copying Data

Printing a Worksheet

Using Data Validation to Control Data Entry

Our Favorite Excel Tweaks and Tips

IN this chapter, we look at Excel’s more advanced features, including a few tricks that make managing large, complicated workbooks easier. We explain how to hide rows and columns, arrange worksheet tabs and windows, and split worksheets into multiple panes so you can scroll without losing your place.

For formatting fanatics, we offer a collection of expert techniques to help you save and reuse custom number formats, cell styles, and workbook themes. If you’re trying to extract the useful parts of big blobs of imported ...

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