Microsoft Office Tutorials and References
In Depth Information
Selecting with Go To Special
another worksheet in another open workbook, open the Go To dialog box and type the
name of the workbook in brackets, followed by the name of the worksheet, an
exclamation point, and a cell name or reference. For example, to go to cell H10 on a worksheet
called Sheet2 in an open workbook called Regional Sales.xlsx, type '[Regional Sales.xlsx]
Sheet2'!D5 . (Note that because there is a space in the name of the workbook, you must
enclose the entire sheet reference in single quotation marks.)
Excel keeps track of the last four locations from which you used the Go To command and
lists them in the Go To dialog box. You can use this list to move among these locations
in your worksheet. This is handy when you’re working on a large worksheet or jumping
around among multiple locations and worksheets in a workbook. Figure 6-6 shows the Go
To dialog box displaying several previous locations.
Figure 6-6 The Go To and Go To Special dialog boxes are your selection transporters.
Note
In the Go To dialog box, Excel displays in the Reference box the cell or range from
which you just moved. This way, you can easily move back and forth between two
locations by pressing F5 and then Enter repeatedly.
Selecting with Go To Special
When you click the Special button in the Go To dialog box (or the Go To Special
command on the Find & Select menu), the dialog box shown on the right of Figure 6-6 opens,
presenting additional selection options. You can think of the Go To Special dialog box as
Search JabSto ::




Custom Search