Easy Reading - large number minus small number

  • Thread starter Thread starter MUTTMIND
  • Start date Start date
M

MUTTMIND

Column A numbers 10 rows down - clear? Column B, a number... smaller than
its A column number: A1 - B1 - clear? Column C says, =A1-B1. Problem, I do
not want to do this step "10 times" - A2-B2, A3-B3. Suggestion - Copy column
A & B into column C and adding the = sign. Me don't know how? You know how?

How would you frame the wording into a searchable subject? Type in your
search words and I get your answer or close to it. In short, what am I
talking about?
I don't know?
Portland, Oregon
 
In C1 after you entered A1-B1 you can copy the formula to other cells in
column C automatically. Put the pointer on C1, Can you see a small square on
bottom left border of C1? Press it and drag as far as you want. This will
copy the formula to rest of the cells.
 
Enter =A1-B1 in C1

Double-click on the fill handle of C1

Fill handle is the litlle black lump at bottom right corner of the cell.


Gord Dibben MS Excel MVP
 
Khoshravan said:
In C1 after you entered A1-B1 you can copy the formula to other cells in
column C automatically. Put the pointer on C1, Can you see a small square on
bottom left border of C1? Press it and drag as far as you want. This will
copy the formula to rest of the cells.
Click to expand...
 
Thank you for your help, I got it. In the easy reading mode, it was not
mentioned what do I do after. The then what?
 
Folks... we got a bingo. Yes Yes Yes! One more time yes... it worked thank
you.
You are my best new friend. I thought no way. But, yes way. Thank you
from the muttmind, portland, oregon
 
Back
Top