Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I jump to a cell in another worksheet | Excel Worksheet Functions | |||
Size Jump | Excel Discussion (Misc queries) | |||
Jump to link worksheet | Excel Worksheet Functions | |||
I want to jump to a worksheet from a contents sheet | Excel Worksheet Functions | |||
HOW TO JUMP TO THE LAST CELL IN A ROW? | Excel Discussion (Misc queries) |