vertical drag & fill problem

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