Sr. Citizens Question, Please
And here's a senior citizen answering.
Select B1 and enter the formula
=A1/10
hit enter
select b1 again and note the little black box (Fill handle) on the bottom
right hand corner.
Double click it and the formula will fill down as far as there are data in
column A
Mike
"Robert11" wrote:
Hello,
Embarrased to ask something so simple, but am in my 70's now, and haven't
used Excel in quite a whle.
Have a long column "A" of numbers.
Would like to create an adjacent column, B, with each number in the first
column A being divided by, e.g., 10.
(and showing up in this adjacent B column)
So, I select the first column, and now what, please ?
Much thanks,
appreciate the help.
Bob
|