• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Mastering Excel Ranges and Formulas > Getting the Most Out of Ranges

Chapter 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 running from B1 to B30. You could enter all 30 cells as arguments in the AVERAGE function, but I'm assuming that you have a life to lead away from your computer screen. Typing =AVERAGE(B1:B30) is decidedly quicker (and probably more accurate).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint