Lesson 7: Jump to Any Sheet with a Shortcut
/en/excel-tips/how-to-quickly-duplicate-a-sheet/content/
See Also
Resize Excel Worksheet TABSGroup worksheets - Microsoft SupportView Multiple Workbooks in ExcelHow to view sheets side by side in ExcelJump to any sheet with a shortcut
If you have a lot of sheets in your workbook, switching between them can be tedious. Instead of scrolling through all of the tabs, you can simply right-click the scroll arrows in the lower-left corner.This will lead to a pop-up window that lists all of your sheets, and you choose the one you want to go to.
Watch the video below to see this shortcut step-by-step.
Steps
- Open your Excel workbook that contains multiple sheets.
- Locate the scroll arrows in the lower-left corner of the Excel window.
- Right-click on or near the scroll arrows, as shown below.
- A dialog box will appear that lists all the sheets in your workbook. Double-click on the sheet that you want to switch to.
- Excel will jump to the selected sheet.
Instead of getting bogged down by the number of sheets you have, give this shortcut a whirl! Read on to discover some ways toselect an entire row or column.
/en/excel-tips/select-an-entire-row-or-column/content/
