+ Reply to Thread
Results 1 to 2 of 2

addition problem

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    addition problem

    I have a problem could someone help me?

    I want to make a list of number for excel to be imported

    1st cell starts with 1 and I need a code/formula to help me fill the whole sheet with numbers

    ex.
    1
    2
    3
    4
    5
    6
    7
    8

    all the way until 10000000

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: addition problem

    Type in 1 in the first row,
    2 in the second row
    Highlight both the cells 1 and 2

    Hold your mouse over the bottom right potion of the array, you'll notice the icon switch to a plus sign. Click and drag down to 10,000 records, and it should auto-fill the numbers in the sequence you created with the first two cells.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1