Excel 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

Creating a worksheet is seldom a one-time experience. In fact, some of the worksheets 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 ...