Excel 2007 help.

Discussion in 'Mac Apps and Mac App Store' started by quagmire, Sep 25, 2009.

  1. quagmire macrumors 603

    quagmire

    Joined:
    Apr 19, 2004
    #1
    I am using the Windows version of Excel for a project and having a little trouble figuring Excel out. The project calls for using the random number generator for data in a table. I used the generator for two columns in the table and now everytime I enter a number into a different column, the columns I used the generator keeps on generating new random numbers even though I need to keep those numbers the same. Help please?
     
  2. nctalkinghead macrumors member

    Joined:
    May 31, 2008
    #2
    excel help

    highlight the cells with your random numbers
    click EDIT > COPY >
    leave the cells highlighted and click EDIT >PASTE SPECIAL
    select the radio button for VALUES, then OK

    Your random numbers will now be values only and will not change when other data are entered on the sheet.
     
  3. quagmire thread starter macrumors 603

    quagmire

    Joined:
    Apr 19, 2004
    #3
    I figured it out. Thanks for the help though. :)
     

Share This Page