Page 201 - Excel 2013 All-in-One For Dummies

Chapter 3: Editing and Proofing Worksheets
In This Chapter
✓ Opening workbooks for editing
✓ Using basic cell-editing techniques
✓ Zooming in and out on the worksheet
✓ Freezing columns and rows on the screen
✓ Copying and moving data entries
✓ Finding and replacing data entries
✓ Proofing the worksheet
✓ Using Data Validation to circle invalid data entries in the worksheet ✓ Finding and eliminating errors with the Text to Speech feature
Creating a spreadsheet is seldom a one-time experience. In fact, some of the spreadsheets that you create with Excel require routine changes on a regular basis, whereas others require more radical changes only once in a while. Regardless of the extent of the changes and their frequency, you can be sure that sooner or later, most of the spreadsheets you create in Excel will require editing.
In this chapter, you find out how to make simple editing changes in a work- sheet by modifying the contents of a cell as well as how to do more complex editing in your worksheets. These techniques include how to use the Undo and Redo features, zoom in and out on data, move and copy data, delete data entries and insert new ones, search and replace data entries, and proof the contents of the final worksheet.
However, before you can use any of these fine editing techniques, you have to open the workbook whose contents require editing. So, with that in mind, this chapter starts out by giving you the lowdown on finding and opening workbooks in Excel.