Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can we look for a number in different spreadsheets?
Hi Guys
How can we look for a number in different spreadsheets? For example, I have 10 spreadsheets in a workbook (all of them with data) and I want to look for a number or a name while I do not know in which spreadsheet this numer or name is, how can I look for it? I know we cannot use Ctrl + F, as it only works in the active spreadsheet. Any help??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can we look for a number in different spreadsheets?
hi
yes you can. on the find dialog, click options. in the within combo box, choose workbook. the find will now search the entire workbook. i am not sure when this feature was introduced but i am fairly certain i was using it in 2000 and now in 2003. not sure about 2007 but i can see why MS would remove it. if your version of excel don't have the option feature see this site. http://www.jkp-ads.com/officemarketplaceff-en.asp it's a free addin called flexfind and it will search the entire workbook. Regards FSt1 "nish" wrote: Hi Guys How can we look for a number in different spreadsheets? For example, I have 10 spreadsheets in a workbook (all of them with data) and I want to look for a number or a name while I do not know in which spreadsheet this numer or name is, how can I look for it? I know we cannot use Ctrl + F, as it only works in the active spreadsheet. Any help??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can we look for a number in different spreadsheets?
I believe 2002 is the first version with this option
The OP can select all sheets and use Find (right click on a sheet tab and choose select all sheets) Do not forget to ungroup the sheets after the search -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FSt1" wrote in message ... hi yes you can. on the find dialog, click options. in the within combo box, choose workbook. the find will now search the entire workbook. i am not sure when this feature was introduced but i am fairly certain i was using it in 2000 and now in 2003. not sure about 2007 but i can see why MS would remove it. if your version of excel don't have the option feature see this site. http://www.jkp-ads.com/officemarketplaceff-en.asp it's a free addin called flexfind and it will search the entire workbook. Regards FSt1 "nish" wrote: Hi Guys How can we look for a number in different spreadsheets? For example, I have 10 spreadsheets in a workbook (all of them with data) and I want to look for a number or a name while I do not know in which spreadsheet this numer or name is, how can I look for it? I know we cannot use Ctrl + F, as it only works in the active spreadsheet. Any help??? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can we look for a number in different spreadsheets?
Ron
In 97 Find would not work across grouped sheets. Replace would work across grouped sheets........go figure<g Gord On Fri, 25 Jul 2008 01:53:55 +0200, "Ron de Bruin" wrote: I believe 2002 is the first version with this option The OP can select all sheets and use Find (right click on a sheet tab and choose select all sheets) Do not forget to ungroup the sheets after the search |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can we look for a number in different spreadsheets?
Hi Gord
Thanks Now I remember about 97 To many Excel versions now to remember all problems <g I hope the OP use 2000 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Ron In 97 Find would not work across grouped sheets. Replace would work across grouped sheets........go figure<g Gord On Fri, 25 Jul 2008 01:53:55 +0200, "Ron de Bruin" wrote: I believe 2002 is the first version with this option The OP can select all sheets and use Find (right click on a sheet tab and choose select all sheets) Do not forget to ungroup the sheets after the search |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting a positive number to neg number in spreadsheets | Excel Discussion (Misc queries) | |||
Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
counting the number of printed spreadsheets | Excel Worksheet Functions | |||
Display a greater number of recently used spreadsheets on File ta. | Excel Discussion (Misc queries) | |||
maximum number of spreadsheets in one workbook | Excel Discussion (Misc queries) |