| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i find data in multiple sheets in excel
I am trying to find data that could be on any of the sheets in my excel work
book is there a way of searchind all sheets at once? |
|
#2
|
|||
|
|||
|
From the Edit menu, choose "Find", click the "Options" button to extend the
dialogbox to show the advanced options. In the "Within" dropdown list, choose "Workbook". Regards, Edwin Tam http://www.vonixx.com "Karline" wrote: I am trying to find data that could be on any of the sheets in my excel work book is there a way of searchind all sheets at once? |
|
#3
|
|||
|
|||
|
Edwin's response will work with xl2002+.
But Jan Karel Pieterse's addin FlexFind: http://www.oaltd.co.uk/MVP/ will work in all versions of xl. Karline wrote: I am trying to find data that could be on any of the sheets in my excel work book is there a way of searchind all sheets at once? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Excel should let me refer to the same formula on multiple sheets | Excel Worksheet Functions | |||
Linear Mode
