Excel 2016 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 ...