How do I switch between Tabs in Excel? 1

[mlrmlr]

Hello,

Can someone tell me how to switch views between tabs in Excel? I use the Alt+Tab keys to switch between open applications, and I desperately need a shortcut method to switch between tabs in an Excel spreadsheet.

Thanks for assisting.

 

[Rofeu]

Alt-PageUp and Alt-PageDown

Cheers,

Roel

 

[AnotherHiggins]

It is not clear what you mean by TABS.

To switch between workbooks within a single session of Excel, use
[ignore][CTRL] + [TAB][/ignore].

To switch between worksheets within a single workbook, use
[ignore][CTRL] + [Page Up][/ignore]
or
[ignore][CTRL] + [Page Down][/ignore]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Rofeu]

oops, of course cntrl instead of alt. Alt-PageUp/Down's for PageRight/Left

 

[mlrmlr]

John,

It was the switch between worksheets within a single workbook that I was looking for.

Thank you so much for your response.

 

[AnotherHiggins]

Glad to help. I do love my keyboard shortcuts....



[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.