Following are 4 different methods that can be used to Jump to the First or Last sheet of an Excel Workbook.
Holding the Ctrl key, left-click on the small right arrow present in the bottom left corner of the workbook. You will land on the last worksheet of the active workbook.
Similarly, to select the first worksheet of a workbook, holding the Ctrl key, left-click on the small left arrow.
Macros created with the following VBA codes can be used to navigate to the first and last sheet of a workbook.
VBA code for selecting the first sheet of a Workbook
Sub JumpToFirstSheet() Sheets(1).Select End Sub
VBA code for selecting the last sheet of a Workbook
Sub JumpToLastSheet() Sheets(Sheets.Count).Select End Sub
Right-click near the control buttons (left and right arrows) for Sheet tabs.
A dialog called Activate with the list of worksheets of that workbook will appear and the same can be used to select any worksheet of our choice.
In the latest versions of Excel, there is a new feature called Navigation Pane which will list every worksheet of a workbook.
This tool also can be used to select the worksheet of our choice.