Excel shortcuts

How to Use the Go to Referenced Cell Shortcut in Excel

If you're like most people, you probably use the mouse to click on cells in Excel. But did you know that you can use the keyboard to quickly move to referenced cells? It's called the Go to Referenced Cell shortcut, and it can save you a lot of time and effort when working in large spreadsheets.

Here's how it works:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example, let's say you have a formula in cell A1 that references cell B1. If you change the value in cell B1, you can use the Go to Referenced Cell shortcut to quickly jump to cell A1 and see the updated formula.

To use the Go to Referenced Cell shortcut:

1. Select the cell that contains the reference to the cell you want to go to.

2. Press F5 to open the Go to dialog box.

3. In the Reference field, type the cell reference of the cell you want to go to.

4. Click OK.

You'll be taken to the referenced cell immediately.

This shortcut is especially useful when you're working with formulas that reference cells in other parts of the spreadsheet. For example

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.