Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 1. Getting the Most Out of Ranges

IN THIS CHAPTER

• Advanced Range-Selection Techniques 7

• Data Entry in a Range 15

• Filling a Range 16

• Using the Fill Handle 16

• Creating a Series 19

• Advanced Range Copying 20

• Clearing a Range 23

• Applying Conditional Formatting to a Range 24

Other than performing data-entry chores, you probably spend most of your Excel life working with ranges in some way. Whether you’re copying, moving, formatting, naming, or filling them, ranges are a big part of Excel’s day-to-day operations. And why not? After all, working with a range of cells is a lot easier than working with each cell individually. For example, suppose that you want to know the average of a column of numbers running from B1 to B30. You could enter all 30 cells ...