Excel for Mac 2008/finding data

Discussion in 'Mac Apps and Mac App Store' started by polina, Dec 30, 2009.

  1. polina macrumors newbie

    Joined:
    Dec 29, 2009
    #1
    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?
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    Are you sure you're not referring to using a filter?
     
  3. polina thread starter macrumors newbie

    Joined:
    Dec 29, 2009
    #3
    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".
     
  4. polina thread starter macrumors newbie

    Joined:
    Dec 29, 2009
    #4
    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. :(
     

Share This Page