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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.