Can I search sheet tabs for names?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel spreadsheets to keep track of all my book authors and titles
-- so I don't duplicate. I have split them into two workbooks based on
author's name - A-L and M-Z. Still there are about 25-50 in each workbook.
Is there a way to search for the name on the sheet tab instead of scrolling
through them?
 
If you right click on the little arrows on the bottom left of your
spreadsheet, then you will see a list of the tabs in your workbook, and you
may well find this an easier way of looking at the names.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Sheet tab names change automatically 3
Tab sheet name 3
FINDING A NAMED TAB 8
Freezing Sheet Tab 2
Navigating worksheet tabs 5
Summary sheet from tab names 3
naming tabs from cells on diff sheet 3

Back
Top