I have a spreadsheet with several tabs that are employee names. I need to
move around quickly. Is there a way I can do a Find to select the tab name
that I need?

Donna;215891 Wrote:
I have a spreadsheet with several tabs that are employee names. I need
to
move around quickly. Is there a way I can do a Find to select the tab
name
that I need?

Hi,
Right-click on the small arrows left of the sheet tabs.

A menu will come up with all the sheet tab names.
Select the one you want

You can also navigate tabs with Ctrl + Page up or page down


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59304

Donna,

One way. Right click the fast forward/rewind button to the left of sheet1
tab (The leftmost sheet) and you get a popup with all your sheet names.
Simply click the sheet you want

Mike

"Donna" wrote:

I have a spreadsheet with several tabs that are employee names. I need to
move around quickly. Is there a way I can do a Find to select the tab name
that I need?

No.

See Pecoflyer's reply for navigating sheets.

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

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 Thu, 5 Feb 2009 12:31:04 -0800, Donna
wrote:

I have a spreadsheet with several tabs that are employee names. I need to
move around quickly. Is there a way I can do a Find to select the tab name
that I need?