Auto Calculate Question / HELP!

A

Andy

When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the
formulas look like:
=D21
=D22
=D23
=D24
=D25

But is there a way for Excel to be adjusted so that they attach the
information laterally instead of veritcally? For example, I want to drag the
auto fill DOWN but want the cells to read:
=D21
=E21
=F21
=G21
=H21

Thank you!
 
T

T. Valko

Try this...

Assume you enter the first formula in cell A1

=INDEX(D$21:H$21,ROWS(A$1:A1))

Drag down as needed. Adjust for the correct end of range H$21.
 
R

Roger Govier

Hi Andy

You can't do it with Autofill
Insert the following formula in the cell where you want to start (ie where
you want the value from D21 to appear) and copy down as far as required
=INDIRECT(SUBSTITUTE(ADDRESS(1,ROW(A4)),"1","")&"21")

--
Regards
Roger Govier

Andy said:
When I click on the fill handle to drag the data down the cells fill with
data grabbed veritcally, for example: When I drag the fill handle down the
formulas look like:
=D21
=D22
=D23
=D24
=D25

But is there a way for Excel to be adjusted so that they attach the
information laterally instead of veritcally? For example, I want to drag
the
auto fill DOWN but want the cells to read:
=D21
=E21
=F21
=G21
=H21

Thank you!

__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top