Auto Fill

  • Thread starter Thread starter JulieD
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
Back
Top