O'Reilly logo

Formulas and Functions with Microsoft® Excel 2003 by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

1. Getting the Most Out of Ranges

IN THIS CHAPTER

A Review of Excel’s Range-Selection Techniques

Advanced Range-Selection Techniques

Data Entry in a Range

Filling a Range

Using the Fill Handle

Creating a Series

Copying a Range

Moving a Range

Inserting and Deleting a Range

Clearing a Range

Using Excel’s Reference Operators

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required