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

Chapter 1. Getting the Most Out of Ranges > Selecting a Range Using Go To

Selecting a Range Using Go To

For very large ranges, Excel's Go To command comes in handy. You normally use the Go To command to jump quickly to a specific cell address or range name. The following steps show you how to exploit this power to select a range:

1.
Select the upper-left cell of the range.

2.
Choose Edit, Go To, or press Ctrl+G. The Go To dialog box appears, as shown in Figure 1.3.

Figure 1.3. You can use the Go To dialog box to easily select a large range.


3.
Use the Reference text box to enter the cell address of the lower-right corner of the range.

TIP

You also can select a range using Go To by entering the range coordinates in the Reference text box.

4.
Hold down the Shift key and click OK. Excel selects the range.

TIP

Another way to select very large ranges is to choose View, Zoom and click a reduced magnification in the Zoom dialog box (say, 50% or 25%). You can then use this “big picture” view to select your range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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