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

Ctrl+PgDn to go to the next sheet, Ctrl+PgUp to go to the previous sheet.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Moises" wrote:

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


"KC Rippstein" wrote:

Ctrl+PgDn to go to the next sheet, Ctrl+PgUp to go to the previous sheet.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Moises" wrote:

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

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
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Moises" wrote:

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


"KC Rippstein" wrote:

Ctrl+PgDn to go to the next sheet, Ctrl+PgUp to go to the previous sheet.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Moises" wrote:

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

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)


On Fri, 19 Dec 2008 15:56:07 -0800, Moises
wrote:

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