CTRL+TAB

[Rodrigo Argento (Brasil)]

Hello guys,

Let me see if you can help me...

How do I do to change CONFIGURATION of CTRL+TAB to change from one WORKSHEET
to another?

 

[Gord Dibben]

If your two worksheets are in separate windows Ctrl +Tab will cycle between
them

To navigate through sheets of a workbook use Ctrl + PageUp and PageDown

To change the behaviour of your Ctrl + Tab would require re-mapping your
keyboard.


Gord Dibben MS Excel MVP

 

[David McRitchie]

Hi Rodrigo,
For a list of Excel keyboard shortcuts, which is a lot easier to read than
trying to work with the one segment at a time in HELP, see
Shortcut Keys in Excel 2000 through Excel 2007
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

FWIW, you really do not want to change keyboard shortcuts in most
cases because they are basically the same shortcuts used in other applications
and by others using Excel.

For instance here is a comparison of browser keyboard shortcuts on Windows
and you will see that the shortcuts for tabs are very similar to Excel because
Excel had tabs before browsers so that is what people were used to.
http://www.mvps.org/dmcritchie/firefox/keyboard.htm

 

[daemonbarber]

Two bits of Code in VBA (ALT+F11 to view):


'Place this in the code for you PERSONAL.XLS 'ThisWorkbook'
Private Sub Workbook_Open()
Application.OnKey "^{TAB}", "nextTab"
Application.OnKey "^+{TAB}", "prevTab"
End Sub

'Add these to a module in the PERSONAL.XLS workbook
Sub nextTab()
If ActiveSheet.Index = Sheets.Count Then
Application.ActiveWorkbook.Sheets(1).Select
Else
Application.ActiveWorkbook.Sheets(ActiveSheet.Index + 1).Select
End If
End Sub

Sub prevTab()
If ActiveSheet.Index = 1 Then
Application.ActiveWorkbook.Sheets(Sheets.Count).Select
Else
Application.ActiveWorkbook.Sheets(ActiveSheet.Index - 1).Select
End If
End Sub

And there you go. It’ll remap your Ctrl+Tab and your Ctrl+Shift+Tab to move
forward or backwards through tabs, wrapping around when it reaches the end.

If you don’t have a PERSONAL.XLS workbook, just record a blank macro and
tell it to save to your Personal Workbook.