Chapter 18. Building a Better Workbook
In this chapter
Working with Worksheets and Workbooks 508
Controlling Data Entry with AutoComplete Options 518
Automatically Filling In a Series of Data 519
Finding, Replacing, and Transforming Data 523
Customizing the Worksheet Window 528
Using Links to Automatically Update or Consolidate Worksheet Data 531
Restricting and Validating Data Entry for a Cell or Range 532
Publishing a Worksheet to the Web 543
Secrets of the Office Masters: Installing and Managing Excel Add-Ins 551
What’s New in Excel 2007
If you’ve ...
Get Special Edition Using Microsoft Office 2007 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.
