Excel formula in Numbers

Discussion in 'Mac Apps and Mac App Store' started by stressymum, Feb 22, 2010.

  1. stressymum macrumors newbie

    Feb 22, 2010
    I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.

    In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another. I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

    If anyone could help with this, I would most appreciate it. Thank you.
  2. mysterytramp macrumors 65816


    Jul 17, 2008
    That's how it SHOULD work in Numbers, too. Could just be there's a subtle change in gestures. At any rate, you can refer to cells within tables:


    Within sheets:

    =Table 1 :: C55

    Within environments:

    =Sheet 1 :: Table 1 :: C55

    When they work, the reference is "bubbled" in a pastel color.

    Quick Numbers plug -- not sure Excel does this, and it's pretty cool -- Let's say you have a table with columns 2008, 2009 and 2010; and rows Sales and Total.

    You can refer to them:

    =Total 2010

    or even

    =2010 Total

    No extra naming needed.

  3. flat five macrumors 603

    flat five

    Feb 6, 2007
    right, that's exactly how numbers works also..
    what is happening to you when you try it?

Share This Page