Chapter 14. Excel 2010 Inside Out
Customizing the Worksheet View
Finding, Editing, Moving, and Copying Data
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 ...
Get Microsoft® Office 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
