Chapter 3

Editing and Proofing Worksheets

IN THIS CHAPTER

check Opening workbooks for editing

check Using basic cell-editing techniques

check Zooming in and out on the worksheet

check Freezing columns and rows on the screen

check Copying and moving data entries

check Finding and replacing data entries

check Proofing the worksheet

check Using Data Validation to circle invalid data entries in the worksheet

check 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 ...

Get Excel 2019 All-in-One For Dummies now with O’Reilly online learning.

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