Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills

helpful when moving around large worksheets containing data that is not always visible in the Excel window.

The Go to list in the Go To dialog box displays the last four references accessed with the Go To feature. You can use this list to quickly return to a recent Go To reference.

Using the Go To dialog box

NOTE You can also use the [Ctrl+G] key combination or the [F5] key to open the Go To dialog box. Excel allows you to give descriptive names to cells and ranges for easy reference. If you name cells or ranges, those names will appear in the Go to list in the Go To dialog box. You can use this list to go to a named cell or cell range.



P ROCEDURES 1. Select the Home tab.

2. Select

in the Editing group.

3. Select Go To . 4. Enter the address of the cell you want to move to in the Reference box. 5. Select .  S TEP - BY -S TEP Use the Go To dialog box to activate a cell.

OFFICEPRO, Inc.

Page 43