Worksheet Jump
 

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?

Worksheet Jump
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TGalin" wrote:

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?