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.
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?
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!