Auto Fill

J

JulieD

Hi Steven

- some people are never satisfied :)

IMHO ... the quickest way ever of filling cells with a formula
1) click in name box to left of formula bar and type the range you want to
populate in there, e.g.
A1:D100 and press ENTER
2) type the formula and then press CONTROL & ENTER

hope this helps
Cheers
JulieD
 
S

Steven Hook

I need to fill several entire columns with a formula, is there a way
(quicker than draging the "auto fill" handle) of filling a colomn at a time
with a formula?
steven
 
J

JulieD

Hi Steven

for two ranges just use a "," between them in the formula bar and press
enter (that is, of course, if it's the same formula you're putting in both)
A2:A65535,D2:D65536

and i've got to ask, WHY are you filling two complete columns with a
formula?

Cheers
JulieD
 
S

Steven Hook

Hi Steven
- some people are never satisfied :)
:)

IMHO ... the quickest way ever of filling cells with a formula
1) click in name box to left of formula bar and type the range you want to
populate in there, e.g.
A1:D100 and press ENTER
Click to expand...

or A2:A65535 and D2:D65536

:) see why I wanted a quick way.
2) type the formula and then press CONTROL & ENTER

hope this helps
Click to expand...

Definately will!
Thanks
Cheers
JulieD
Click to expand...

If I could ask toy one more, need to take numbers from a list (the list is
R1:R20) and use them randomly to fill cells C2:H65535 on 15 sheets , BUT no
row can have nore than 2 of the same number, I don't know if it'll be
possible, but it's a lot of cells to fill be hand!
Maybe a macro?

Thanks again!
Steven
 
S

Steven Hook

JulieD said:
Hi Steven

for two ranges just use a "," between them in the formula bar and press
enter (that is, of course, if it's the same formula you're putting in both)
A2:A65535,D2:D65536
and i've got to ask, WHY are you filling two complete columns with a
formula?
Click to expand...

I work for a printing company, our digital press (HP Indigo) takes stuf
ffrom an excell spreadsheet to print on the pages so that each page can be
diferent, this is quite new to high volume printing.
anyway, we're printing scratc cards for some Central African country and
obviously each of the 1000000 cards needs to be unique, and the cards need
to be in a random order, so to randomise them I put "=RAND()*(1000-1)+1" in
colomn a and then sort it numerically.

the other column is
"=IF(COUNTIF(C65478:H65478,MODE(C65478:H65478))>=3,MODE(C65478:H65478),"no
match")" to check for "winning" cards, I still need to modify this formula
to give an error if there are two "triplets" if you understand.

Did you read the end of my previous post, about macros?

Steven
 
Top