Excel shortcuts

How to create a Go To Shortcut in Excel

If you work with large spreadsheets in Microsoft Excel, you know how frustrating it can be to scroll across the sheet to find the data you need. The Go To command can help you quickly find and select specific cells in your worksheet. You can access the Go To command in the Find & Select group on the Home tab.

To use the Go To command, follow these steps:

  1. Click the Home tab.
  2. In the Find & Select group, click Go To.
  3. In the Go To dialog box, click the Special button.
  4. In the Go To Special dialog box, select the cells you want to select, and then click OK.

For example, if you want to select all cells that contain errors, select the Errors option. Or, if you want to select all cells that contain formulas, select the Formulas option.

You can also use the Go To command to find specific text or numbers in your worksheet. To do this, follow these steps:

  1. Click the Home tab.
  2. In the Find & Select group, click Go To.
  3. In the Go To dialog box, click the Find button.
  4. In the Find and Replace dialog box, enter the text or numbers you want to find, and then click Find All.
  5. Excel will select all cells that contain the text or numbers you entered.

You can then use the standard Excel selection commands to select the cells you want to work with. For example, you can press Ctrl+A to select all cells, or you can use the arrow keys to select a specific range of cells.

The Go To command is a great way to quickly find and select specific cells in your worksheet. By using the Go To command, you can save time and make your work with large spreadsheets much easier.

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.