So, then, you are saying one of the key things to do when reading newsgroup
messages is to use the scroll bar too?<g
I could say, "Sorry for having missed that in your message", but let's just
say I was reinforcing your point instead, okay?<vbg
Rick
"Ragdyer" wrote in message
...
It appears that you didn't read my first post in it's entirety!<bg
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rick Rothstein (MVP - VB)" wrote in
message ...
Or, alternately, do the first part of what you said in your first post
(put
=A1*7 in B1; click back in B1 to select it) and then simply double-click
that little black square.
Rick
"Ragdyer" wrote in message
...
In re-reading your post, here's the procedure that I believe you
alluded
to:
Click in B1 and drag down to select as many rows as you need.
With B1 the cell in focus (colored white), type in this formula:
=A1*7
THEN, hold down <Ctrl and hit <Enter.
This will fill all the selected cells in Column B with the formula.
Is that what you were after?
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Ragdyer" wrote in message
...
Say your numbers start in A1.
In B1, enter this formula:
=A1*7
Click back in B1 to select it.
Hover your cursor over the lower right corner of B1, where you see a
tiny
black square.
When the cursor changes from a fat white cross to a skinny black
cross,
click and drag down Column B as far as needed.
XL will *automatically* change the cell reference in the formula to
match
the row that the formula is in.
If you have no blank rows in Column A between your numbers, you can
have
XL
*automatically* copy the formula down Column B, as far as there are
numbers
in Column A, by *double clicking* on that tiny black square when the
cursor
changes to the skinny black cross.
--
HTH,
RD
-------------------------------------------------------------------------
-
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!
-------------------------------------------------------------------------
-
-
"Andrea Gates" wrote in message
...
How to multiply entire colume with constant:
For example I have colume A
21
26
28
33
77
I wish to multiple all of colume A with 7 and put product result in
colume
B
21 147
26 182
28 196
33 231
77 539
how do I insert single formula vulue in colume B at one time during
edit?
(by selecting all the cells in colume B)?
Thank you.