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
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
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks