Navigate and navigate between sheet tabs in Excel

Content
  1. Navigating to different data areas is easier than you think
  2. Use keyboard shortcuts to change worksheets in Excel
  3. Switch between sheets with keyboard shortcuts
  4. Using “Go To” To Navigate Excel Spreadsheets
  5. Other ways to go
  6. Save cell references for reuse
  7. Navigate with an example Go to
  8. Navigate between sheets with “Go to”
  9. Using the name field to navigate Excel tables
  10. Active link to a cell in the name field
  11. Name navigation
  12. Navigate between worksheets with a name field

Navigating to different data areas is easier than you think

There are many ways in Excel to move to different data areas on a worksheet or between different worksheets in the same workbook. To some methods, such as the command To go , can be opened using keyboard shortcuts, which are sometimes easier and faster to use than a mouse. But follow our complete guide to find the best fit for your workflow.

Use keyboard shortcuts to change worksheets in Excel

Switching between worksheets in an Excel workbook is easy enough by clicking the tabs at the bottom of the worksheets, but it’s a slow way to do it – at least in the opinion of those who prefer keyboard shortcuts or hotkeys. keys if possible.

Coincidentally, Excel has keyboard shortcuts for switching between sheets; keys used:

  Ctrl  +  PgUp  (страница вверх) - переместите один лист влево. 
Ctrl + PgDn (страница вниз). Переместите один лист вправо.

Switch between sheets with keyboard shortcuts

To go right:

  1. Press and hold a key ctrl on keyboard.

  2. Press and release the button PgDn on keyboard.

  3. To move another sheet to the right, short press the key PgDn a second time.

To go left:

  1. Press and hold a key ctrl on keyboard.

  2. Press and release the button pgup on keyboard.

  3. To move another sheet to the left, short press the key pgup a second time.

Using “Go To” To Navigate Excel Spreadsheets

Team To go in Excel can be used to quickly navigate to different cells on a worksheet. Although the use To go not very useful for worksheets with only a few columns and rows, for large worksheets this is another way to move from one area of ​​the worksheet to another.

  1. Select a menu item Change .

  2. Select Find on the list .

  3. Choose an option To go… .

  4. Enter a reference to the destination cell in the row Clutch at the bottom of the dialog box.

  5. Click Okay or press the key Enter on keyboard.

As a result, the selection of the active cell moves to the cell reference entered in the dialog box.

Other ways to go

Team To go can also be activated with the following keyboard shortcuts:

  • Press a key F5 on keyboard.

  • By pressing key combinations ctrl + G on keyboard.

Save cell references for reuse

Additional function To go is that it saves previously entered cell references in a large window To go at the top of the dialog box for future reference. If you switch between two or more leaf areas, To go can save you even more time by reusing cell references stored in the dialog box.

Cell references are saved in the dialog box as long as the workbook remains open. After closing the saved list of cell references in the dialog box To go is removed.

  1. Click F5 or ctrl + G on the keyboard to open the dialog box To go .

  2. Enter the cell reference of the desired destination in the row Clutch dialog box.

  3. Press the button Okay or press the key Input on keyboard.

  4. The black box around the active cell should now move to the new active cell.

To go can also be used to navigate to different sheets in the same workbook by entering the sheet name along with a cell reference.

Exclamation mark (! ) above the number a on the keyboard, is used as a separator between the worksheet name and the cell reference, because spaces are not allowed. For example, to go from sheet 1 to cell HQ567 on sheet 3 enter Sheet3!HQ567 in the edit line of the dialog To go and press the key Input .

Using the name field to navigate Excel tables

As seen in the image above, the “Name” field is located above column A on an Excel sheet and can be used to navigate to different parts of that sheet using cell references.

As in the case of the command To go , boxing names may not be useful for tables with only a few columns and rows of data, but for larger tables or those with separate data areas, using a name field to quickly jump from one place to another can be a very efficient way of working .

Unfortunately, there is no keyboard access to the name block without creating a VBA macro. For normal operation, you need to click name field .

Active link to a cell in the name field

Typically, the Name field displays a cell reference or named range for the current or active cell: a cell in the current worksheet that is surrounded by a black border or box.

When entering a new cell reference or range name in Window name and press a key Enter the active cell changes and the black box moves and whatever is visible on the screen to a new location.

  1. Press Name field above column A to highlight the link to the active cell.

  2. Enter cell reference desired destination .

  3. Press key Enter on keyboard.

  4. The black box around the active cell should go to the newly selected active cell.

Like it To go , Window name can also be used to navigate to different sheets in the same workbook by entering the sheet name along with a cell reference.

Leave a Reply

Your email address will not be published.