Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
21 Posts
Discussion Starter · #1 ·
I know that I can use the "find" feature to look up an item on a particular sheet in a workbook, but is there a way of using find to look up the same item in the entire workbook? It is laborious to have to go sheet to sheet to find an item.
Thanks
 

·
Registered
Joined
·
15 Posts
Yes! There is a way!

First, To select all sheets in the workbook, do this:

Right-click a sheet tab, and then click "Select All Sheets" on the shortcut menu.
Then, go to Edit, Find (or ctrl+f)and enter what data you want to find. It will search through the active sheet first and then to the rest of the sheets in the workbook,

I know I can sometimes be unclear. Does this help you?
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top