vertical drag & fill problem

J

juan_pablo

Hi everyone,

Is it possible to drag & fill a formula vertically with lette
increments? Let's say we have =A1 in a cell and in below cells I wan
to have B1, C1, D1,... by just draggin and filling.

Thank
 
D

DDM

Juan_Pablo, if =A1 is in a cell and you want to copy it down:

1-Click the cell
2-Observe the Cell Pointer (black box around the cell). Specifically, note
that there is a little black box in the lower right corner of the Cell
Pointer. That's the Fill Handle.
3-Rest your mouse cursor on the Fill Handle. It will change from a big white
plus sign to a thin black plus sign.
4-Press and hold the left mouse button.
5-Drag your mouse as far down the column as you need to.

When you release the left mouse button, you'll see that =A1 has become =B1,
=C1, etc. as you dragged it down the column. This is because "A1" is a
relative cell reference.

When you have time, search the topic "About Cell and Range References" in
Excel help, and scroll down to the discussion of Relative vs Absolute Cell
References.
 
R

RagDyer

Have YOU tried it?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Juan_Pablo, if =A1 is in a cell and you want to copy it down:

1-Click the cell
2-Observe the Cell Pointer (black box around the cell). Specifically, note
that there is a little black box in the lower right corner of the Cell
Pointer. That's the Fill Handle.
3-Rest your mouse cursor on the Fill Handle. It will change from a big white
plus sign to a thin black plus sign.
4-Press and hold the left mouse button.
5-Drag your mouse as far down the column as you need to.

When you release the left mouse button, you'll see that =A1 has become =B1,
=C1, etc. as you dragged it down the column. This is because "A1" is a
relative cell reference.

When you have time, search the topic "About Cell and Range References" in
Excel help, and scroll down to the discussion of Relative vs Absolute Cell
References.
 
S

Sandy Mann

There may be better ways but with you formula, ie the *=A1* cell, starting
in cell H16 then:

=INDIRECT(CHAR(ROW()-ROW($H$15)+64)&1)

will give you the value in Cell A1 and dragging it down the column will give
the values in B1,C1 etc

HTH

Sandy
 
D

DDM

Dyer, good catch. That's what I get for answering posts while half-asleep!
Juan_Pablo, disregard.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


RagDyer said:
Have YOU tried it?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Juan_Pablo, if =A1 is in a cell and you want to copy it down:

1-Click the cell
2-Observe the Cell Pointer (black box around the cell). Specifically, note
that there is a little black box in the lower right corner of the Cell
Pointer. That's the Fill Handle.
3-Rest your mouse cursor on the Fill Handle. It will change from a big white
plus sign to a thin black plus sign.
4-Press and hold the left mouse button.
5-Drag your mouse as far down the column as you need to.

When you release the left mouse button, you'll see that =A1 has become =B1,
=C1, etc. as you dragged it down the column. This is because "A1" is a
relative cell reference.

When you have time, search the topic "About Cell and Range References" in
Excel help, and scroll down to the discussion of Relative vs Absolute Cell
References.
Click to expand...
 
Top