Force Byte - 'Go to' command in Excel

0 Photo

This time I will talk about the powerful "Go To" command. It can let you:

A. quickly move to and select a cell

B. easily drag through all the cells you want to work with

C. move to another worksheet in the same workbook

D. keep track of the locations visited and easily move back and forth among them

For A: You can choose the "Go To" option from the "Edit" menu or simply press the key. Then enter the cell reference (e.g. "A1", which represents the cell in column A of the first row), range reference (e.g. "A1:Z100", which represents a range of cells between A1 and Z100), or defined cell name (i.e. a user-defined name to represent a cell or a cell range) in the Reference edit box of the "Go To" dialog box and click "OK".

For B: To select "A1:Z100", first mouse-click the cell "A1" once, choose the "Go To" option, type "Z100" in the Reference edit box, and then hold down the key while pressing the key.

For C: Choose the "Go To" option and type the name of the worksheet, followed by an exclamation mark (!) and a cell name or reference. For example, to go to cell "D5" in the worksheet called "Sheet2", type "Sheet2!D5" in the Reference edit box.

For D: Excel will list in the Reference edit box with the cells or ranges of cells from which you just move when using the "Go To" option. This enables you to easily move back and forth between two locations by repeatedly pressing the key and then the key. In addition, Excel will keep track of the last four locations visited and list them inside the "Go To" selection box. You can simultaneously press the and key in the "Go To" dialog box to gain access. Then use the upward and downward arrow keys to select the target location. Once selected, just press the key.

Next time, I will further elaborate how to name the cells and the ranges in Excel.

"Sharing IT as it applies to your daily life"