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?
|