CTRL + Pageup or Pagedown to move one sheet at a time.

You can right-click on the navigation arrows at lower left end of sheet tabs bar
and get a list of 15 sheets and "more sheets" to select from.

O)r you can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 11:39:00 -0700, Jay Lee <Jay
wrote:

I am wondering how can i move between tabs in a spreadsheet. For example, i
have 10 tabs in a spreadsheet, and i wanted to move between tab1 and tab5, is
there a quick way of switching tab1 and tab5? ( like how we can use Alt-Tab
to move between spreadsheets)