Easy Reading - large number minus small number

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
 
K

Khoshravan

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.
 
G

Gord Dibben

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
 
M

MUTTMIND

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.
 
M

MUTTMIND

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?
 
M

MUTTMIND

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top