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.

"MUTTMIND" wrote:

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

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

On Mon, 2 Feb 2009 14:09:01 -0800, MUTTMIND
wrote:

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

"Khoshravan" wrote:

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.

"MUTTMIND" wrote:

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

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?

"Gord Dibben" wrote:

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

On Mon, 2 Feb 2009 14:09:01 -0800, MUTTMIND
wrote:

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

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

"Khoshravan" wrote:

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.

"MUTTMIND" wrote:

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