search for word/number in excel workbook utilizing all tabs

G

Guest

In excel workbook, and using the tabs on the bottom can I search through all
tabs for a specific word/or number without searching each tab?
 
N

N Harkawat

Select the right most tab
Pressing the shift key now select the left most tab
This way all tabs are selected.
Now do your search
It will searchj all the sheets
 

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

Serious Excel Challenge 0
Excel Compare numbers on 1 tab to other tabs in workbook. 1
Display tabs for all worksheetts at bottom 2
Reference the same cell based on tab name 1
adding a search box to a spreadsheet 1
how to search values ont several tabs 1
Tabs Names 3
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0

Top