Selecting cells with Go to in Microsoft excel

 

Selecting cells with Go To

1. Select the first cell of the range. This becomes the active cell to which the cell range is anchored.

 2. On the Ribbon, click the Find & Select command button in the Editing group on the Home tab and then choose Go To from its drop-down menu or press Ctrl+G or F5. The Go To dialog box opens. Book II Chapter 2 Worksheets Formatting 3. Type the cell address of the last cell in the range in the Reference text box. If this address is already listed in the Go To list box, you can enter this address in the text box by clicking it in the list box.

4. Hold down the Shift key as you click OK or press Enter to close the Go To dialog box. By holding down Shift as you click OK or press Enter, you select the range between the active cell and the cell whose address you specified in the Reference text box.