Going from one Sheet to another in the same file

[Moises]

I have a file with more than 10 Sheet tabs, is there a short cut to go from
one sheet to another ?
The sheet tabs are in the same file.
Something similar to what we have in order to go from one cell to another
pressing the F5 key ?

Thanks

 

[KC Rippstein hotmail com>]

Ctrl+PgDn to go to the next sheet, Ctrl+PgUp to go to the previous sheet.

 

[Moises]

KC,
Thanks.
There is a way to go to a known Sheet tab, for example I am in Sheet 1 and I
need to go to the Sheet named "INV", and this sheet is not after or before
the Sheet 1.

Thanks

 

[KC Rippstein hotmail com>]

you can right click on the sheet navigator in the lower left corner of the
sheet to see a pop up showing all your sheets. clck one to go to it.
if you have more than 15 sheets, there will be a "more sheets" option...
click that and you get a scrollable list of all of your sheets

 

[Chip Pearson]

Here's a bit of code you can use. You can run the code directly or
assign it to a keyboard shortcut. When the prompt displays, enter the
number corresponding to the worksheet name.

Sub NavSheets()
Dim N As Long
Dim S As String
With ActiveWorkbook.Worksheets
For N = 1 To .Count
S = S & CStr(N) & " " & .Item(N).Name & vbCrLf
Next N
N = Application.InputBox(prompt:="Select A Sheet." & vbCrLf & _
S, Type:=1)
If N >= 1 And N <= .Count Then
.Item(N).Select
End If
End With
End Sub

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)