Worksheet Jump

  • Thread starter Thread starter TGalin
  • Start date Start date
T

TGalin

If I am on Sheet 50 and I want to get to Sheet 1. I can Press Ctrl Pg Up and
I will arrive at Sheet 1. I am wondering is there a faster way to jump from
Sheet 50 to Sheet 1?
 
Hi,

that depends. Is sheet1 the first sheet in the workbook, if so right-click
any of the tab scrollers and pick Sheet1 from the popup list.

If not, type Sheet1!A1 in the Name Box on the left side of the Formula Bar
and press Enter.

Or write a macro

Sub GoToSheet1()
Sheets("Sheet1").Activate
End Sub

Assign a shortcut key such as Ctrl+e and you will be able to get there in
one step.
 
Back
Top