Chapter 5. Modifying the Spreadsheet
In This Chapter
Selecting the cell ranges that require editing
Finding data entry errors with Text to Speech
Inserting and deleting cell ranges
Moving and copying cell ranges
Using comments in the spreadsheet
Finding and replacing cell entries and spell checking the spreadsheet
Editing worksheets as a group
Some of the spreadsheets you work with may require constant updating, whereas others need only the occasion revision. Whichever is the case, being able to revise an existing spreadsheet without disturbing either its underlying structure or its current contents is essential. The exercises in this chapter give you a chance to practice all aspects of basic editing, including locating the workbook file to open, finding the area in the worksheet that needs editing, and making all the necessary editing changes.
Finding and Identifying the Region That Needs Editing
As you're already well aware, an Excel worksheet represents an extremely large space in which to work. Often the biggest challenge in editing a spreadsheet is just finding and identifying the data ranges in the worksheet that are in need of revision. To help in this endeavor, you can often use the following three features to good advantage:
Zoom to gain an overview of the worksheet and its data ranges by zooming out on the worksheet and then using it to gain a close-up view of the particular range in the sheet you need to edit
Freeze Panes to prevent the rows and columns containing the column and ...
Get Excel® 2010 Workbook for Dummies® 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.