How to Use a Basic GoTo Command

Using a basic GoTo command can make using a spreadsheet easier. If you have thousands of entries, a GoTo command is almost mandatory. After learning how to use the GoTo command, you will see how navigating a spreadsheet sheet can be as easy as 1, 2, 3.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Computer
• Spreadsheet Software

1. Select "Edit" "Go To". You can select an item. The item can be a cell, range, chart, drawn object or query table. A range name can be set up at any time which will make selection easier.
2. In the "Type of item" drop-down box, select the item type.
3. To go to an item in another open file, select the file in the "In file" drop-down box.
4. Enter the name of an item in the text box, or select the item in the list box.
5. Choose OK.
6. “F5" (GoTo) is equivalent to "Edit Go To." It moves the cell pointer to a specified cell, a named range, another worksheet, another active file, a drawn object, a chart or a query table. When you go to another worksheet or file, 1-2-3 moves the cell pointer to the cell you last highlighted in that worksheet or file.

Tips & Warnings

• Set up multiple data ranges. This will allow you to use the GoTo command easier.
• Multiple data ranges are not necessary if you only have a small spreadsheet.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.