How to toggle from Two Worksheets

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Does anyone know a shortcut for toggling from one worksheet to the
next within the same workbook (preferably without having to create a
new Window)?

Thanks.
 
<Ctrl> <PageUp>
<Ctrl> <PageDown>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Does anyone know a shortcut for toggling from one worksheet to the
next within the same workbook (preferably without having to create a
new Window)?

Thanks.
 
<Ctrl> <PageUp>
<Ctrl> <PageDown>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Does anyone know a shortcut for toggling from one worksheet to the
next within the same workbook (preferably without having to create a
new Window)?

Thanks.
Click to expand...

Thank for the response. But I probably should have clarified my
question. Is there a way to go back and forth from Spreadsheet A and
Spreadsheet B (when they are not directly next to one another)?
Perhaps there is a way to go to the last active cell.......
 
If you opened both worksheets with the same instance of Excel (using
File>Open), then Ctrl-Tab will switch between them.


HTH,
JP
 
Sub Toggle_Sheets()
With ActiveWindow
If ActiveSheet.Name = "SheetA" Then
Sheets("SheetB").Activate
Else
Sheets("SheetA").Activate
End If
End With
End Sub


Gord Dibben MS Excel MVP
 
Have your tried Hyperlinks?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<Ctrl> <PageUp>
<Ctrl> <PageDown>
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Does anyone know a shortcut for toggling from one worksheet to the
next within the same workbook (preferably without having to create a
new Window)?

Thanks.
Click to expand...

Thank for the response. But I probably should have clarified my
question. Is there a way to go back and forth from Spreadsheet A and
Spreadsheet B (when they are not directly next to one another)?
Perhaps there is a way to go to the last active cell.......
 
Back
Top