Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Excel 2010 Inside Out
CHAPTER 14
Excel 2010 Inside Out
Customizing the Worksheet View . . . . . . . . . . . . . . . . . . 451
Advanced Worksheet Formatting . . . . . . . . . . . . . . . . . . 458
Finding, Editing, Moving, and Copying Data . . . . . . . . . 465
Printing a Worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 468
Using Data Validation to Control Data Entry . . . . . . . . . 474
Our Favorite Excel Tweaks and Tips . . . . . . . . . . . . . . . . . 478
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 text, you’ll appreciate our instructions on how
to transform and manipulate text with the help of the Clipboard and some arcane but
extremely useful functions. We also show you how to prevent data-entry errors.
Finally, we examine some of our favorite Excel tweaks, including how to replace the default
workbook template and how to automatically enter custom lists into a worksheet.
Customizing the Worksheet View
During the design and construction stages of any workbook, you probably want ready
access to all of Excel’s tools. But after construction is complete and you no longer need
those tools, it’s sometimes useful to hide them so you have more room to view charts,
tables, and other worksheet contents. On the View tab, in the Show group, you’ll find check
boxes that allow you to temporarily remove any (or all) of four prominent features from the
Excel interface:
Clear the Gridlines option to remove the lines that define the edges of rows and columns
and thus separate cells from each other. Clear the Headings check box to remove the labels
451
Search JabSto ::




Custom Search