Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

polina

macrumors newbie
Original poster
Dec 29, 2009
4
0
Hi, everybody,
in my old old old excel 2003 when i was searching for some words in excel sheet ( e.g. in the column) i could choose "to find all" option. So i saw all the results in the "find" window. In excel 2008 for Mac i can see search results only one by one not altogether. On microsoft site http://www.microsoft.com/mac/help.m...-US&usid=eaefd262-55f7-472f-874f-17820d214cef
i couldn`t find tha answer also. Does anyone know how to make it in excel 2008 for mac so i could see all search results in the "find" window?
 
Are you sure you're not referring to using a filter?
no, no not a filter:)
i need to use this search for my work -
1)i select the range of cells for my search then
2)on the Edit menu, click Find then
3)in the Find what box (pop up window), type the text or numbers that need to find
4) in the old excel i can choose find all button and see all the matches in the find what box (pop up window). in the excel 2008 for mac i can see only one match in this window to see the next match i need to push "find next".
 
After couple of hours of thinking i called to our Microsoft rep in my country. They said that this function is not available for Mac only for Microsost. :(
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.