|
Irisheyes
|
03-28-2006, 08:55 AM
Post subject: A little help with Excel please?
|
#1 (permalink)
|
|
4-of-a-Kind
Join Date: Jun 2005
Location: over there
Posts: 3,708
|
|
I need to enter a huge list of numbers, like from 1 to 20 in .001 steadily increacing increments. Is there some function or something I can use to do this for me instead of trying to type them all out by hand? That could take me 3 days.
ty
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
arkana
|
|
Full House
Join Date: Mar 2005
Posts: 1,109
|
|
Enter 1 in the first cell, then click on the cell below and add the formula =A1+0.01
Then just click on the bottom right corner of that cell while its selected (cursor should be a +) and drag down as far as you want.
|
|
|
|
DogOnMySide
|
|
Flush
Join Date: Apr 2005
Location: Manchester, UK
Posts: 458
|
|
Yep.
In the first box write 1
in the second, type the equals sign, which puts you in formula mode. Then click on the first box... which should put the reference of the first box in the formula bar, which will now read something like "=A2"
now type +0.01 and press enter
that box should now read 1.001, but it's contents are actually "=A2+0.01"
what you will see is that the box highlighting the cell has a little black square in the bottom right corner. grab that and drag downwards a few cells.....
you should find it "Fills down" the spreadsheet
1.001
1.002
1.003
and so on.
now you just have to drag that box a few hundred cells down.
helpful?
|
|
|
|
Irisheyes
|
|
4-of-a-Kind
Join Date: Jun 2005
Location: over there
Posts: 3,708
|
|
Quote:
|
Originally Posted by arkana
Enter 1 in the first cell, then click on the cell below and add the formula =A1+0.01
Then just click on the bottom right corner of that cell while its selected (cursor should be a +) and drag down as far as you want.
|
Genius, why didn't I think of that. Thanks guys.
|
|
|
|
Lukie
|
|
4-of-a-Kind
Join Date: Jul 2005
Location: back with a vengeance
Posts: 3,307
|
|
You may be able to pick up other useful bits about Excel in Trip's 'random thread.'
|
|
|
|
lolzzz_321
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
Hahqhaaha, i bwn excel.
|
|
|
|
Irisheyes
|
|
4-of-a-Kind
Join Date: Jun 2005
Location: over there
Posts: 3,708
|
|
Wow  Trip
|
|
|
|
biondino
|
|
4-of-a-Kind
Join Date: Apr 2005
Location: Putney, UK; Full Tilt,Mansion; $50 NL and PL; $13 and $16 SNGs at Stars
Posts: 3,170
|
|
Omg how did I end up in trip's sig?
|
|
|
|
lolzzz_321
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
For being awesome.
|
|
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
