How do I fill a column with numbers and equations automatically in Numbers?

Discussion in 'Mac Apps and Mac App Store' started by chrono1081, Jul 17, 2010.

  1. chrono1081 macrumors 604

    chrono1081

    Joined:
    Jan 26, 2008
    Location:
    Isla Nublar
    #1
    Hi guys.

    I've been ripping my hair out trying to find the answer to this.

    In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.

    For example:

    Column A - 1 - 5
    Column B - (value in Column A * 5)

    I can't figure out how to do it in Numbers :( When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.

    The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
     
  2. chrono1081 thread starter macrumors 604

    chrono1081

    Joined:
    Jan 26, 2008
    Location:
    Isla Nublar
    #2
    Found it!

    You have to type "=Row()" and then drag the little corner down to as many cells as you want filled :)
     

Share This Page