Going from one Sheet to another in the same file

  • Thread starter Thread starter Moises
  • Start date Start date
M

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
 
Ctrl+PgDn to go to the next sheet, Ctrl+PgUp to go to the previous sheet.
 
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
 
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
 
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)
 
Back
Top