Searching across a workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle York - 20 Jul 2006 00:56 GMT

Is there a way to search for something across an entire workbook? I know
that you can search within each individual worksheet, but I'd like to be
able to do the same across the entire book.

Reply to this Message

Jim Gordon - 20 Jul 2006 02:20 GMT

Hi Michelle,

I presume you must have embedded the Excel workbook into a PowerPoint
presentation, which is why you posted to the PowerPoint group, right?

Regardless, you simply have to hold the Apple key down and click on the
sheet tabs that you wish to search upon before starting the search. If
you want to search an entire workbook you can use Apple+A to select all
of the sheet tabs.

-Jim Gordon
Mac MVP

> Is there a way to search for something across an entire workbook? I know
> that you can search within each individual worksheet, but I'd like to be
> able to do the same across the entire book.

Reply to this Message

Mac Forum / Applications / PowerPoint / July 2006

Searching across a workbook