Is there a keyboard shortcut to switch between worksheets in excel?

[FortFunFoSho]

Have always wondered this and have spent the last couple of minutes trying to search but have not come up with anything yet....

 

[sswingle]

Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document


First google result.

 

[alkemyst]

Ctrl-Tab will also flip through multiple workbooks.

 

[spidey07]

Originally posted by: alkemyst
Ctrl-Tab will also flip through multiple workbooks.

not only that, but that's a windows function...not just excel. It will cycle through whatever windows you have open in the application.

 

[alkemyst]

shortcut keys rock...what I seriously hate is the latest keyboards getting rid of the right side windows key.

On a busy day with a messy desk and no mouse movement makes blowing through documents and programs a breeze.

Å

 

[sswingle]

Ctrl+Tab isn't doing a thing for me. Either switching between two separate excel windows, or switching tabs within excel.

 

[halik]

Originally posted by: ScottSwingleComputers
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document


First google result.

 

[alkemyst]

Originally posted by: ScottSwingleComputers
Ctrl+Tab isn't doing a thing for me. Either switching between two separate excel windows, or switching tabs within excel.

I don't understand.

Open two spreadsheets in excel....focus on one, ctrl-tab should swap to the other one.

If you are trying to change sheets within one 'workbook', use ctrl-page up or down.

 

[dman]

Is there anyway to make two separate files open up in separate windows, like if you open two documents in word you get two separate windows?

 

[spidey07]

Originally posted by: dman
Is there anyway to make two separate files open up in separate windows, like if you open two documents in word you get two separate windows?

That's the default behavior I thought. Always opens separate windows that you can alt-tab between for me in 2003.

 

[alkemyst]

Originally posted by: spidey07

Originally posted by: dman
Is there anyway to make two separate files open up in separate windows, like if you open two documents in word you get two separate windows?

That's the default behavior I thought. Always opens separate windows that you can alt-tab between for me in 2003.

need to go to the options tab and pick make new windows.

That behavior started recently...

 

[Dessert Tears]

Originally posted by: ScottSwingleComputers
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document

This tends to work in other tabbed applications also, e.g. Firefox and Eclipse.

Originally posted by: alkemyst
Ctrl-Tab will also flip through multiple workbooks.

Adding Shift to Tab-based shortcut keys (e.g. Ctrl-Shift-Tab or Alt-Shift-Tab) generally makes them move their selection in the opposite direction.