How to substruct in a range of cells?

[ilyaz]

I have a table with 3 columns and several hundred rows. In column A entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age from the
year. Using formula for the first row =A1-B1 gives the correct answer. But
I'd like to enter data in all cells in column C at once. Whatever I do, I'm
getting the error.
May someone please guide me through this process? What formula should I use?
I'll appreciate your help.

 

[ilyaz]

Please disregard this request. I solved my problem.
Ilya

 

[JMB]

Select the cell w/your formula A1-B1. Put the cursor over the black box, it
should change to a black cross. Click left mouse button and drag down as far
as needed, then let up on the mouse button.

 

[ilyaz]

Thanks, JMB. Appreciate your advice!
Ilya

Select the cell w/your formula A1-B1. Put the cursor over the black box,
it
should change to a black cross. Click left mouse button and drag down as
far
as needed, then let up on the mouse button.

 

[Gord Dibben]

Easier yet...........double-click on the black cross.

No dragging involved.


Gord Dibben MS Excel MVP

 

[ilyaz]

Thanks, Gord! But I got your advice to late for this job. Will use it next
time!
Ilya

 

[Gord Dibben]

One more arrow for your quiver.

Gord

Thanks, Gord! But I got your advice to late for this job. Will use it next
time!
Ilya

Gord Dibben MS Excel MVP