Andrea

Another approach: In C1 place the number 7, In B1 enter =A1:A5*$C$1. Then
do what Ragdyer suggested to move the formula to the bottom of you data. if
it has no blanks method work really fast! The nice part about this set up is
if you need to change the multiplier (7) to a different number you can do so
without changing anything else.

Mike Rogers

"Andrea Gates" wrote:

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.