Chapter 5. More Editing in a Spreadsheet

5. More Editing in a Spreadsheet

IN THIS CHAPTER

• Naming a range

• Automatically filling a range with numbers

• Finding and replacing information

• Using QuickCorrect

• Introduction to the Quattro Pro Experts

You'll probably spend more time editing in a spreadsheet than anything else you'll do. So, we need to cover a few more editing techniques that I think you'll make use of on a regular basis. In this chapter, I'll show you how to automatically fill a range with numbers and how to assign names to ranges so that you can refer to the range by its name instead of the cell addresses of the range's upper-left and lower-right cell. Then, I'll show you how to use the Find and Replace feature in Quattro Pro to help you quickly change all occurrences of information you specify.

Last, we'll go over the spell-checking features available in Quattro Pro, and then I'll provide a brief overview of the Quattro Pro Experts. When you finish this chapter, you'll have completed the basics of using Quattro Pro.