Originally Posted by
Ron Coderre
Try one of these approaches:
C3: =B3-A3
Method_1:
Left-Click and HOLD on the lower right corner of cell C3
(that corner will have a small black box...and the cursor will turn into a cross when you hover over it.)
Drag the formula down as far as you need.
OR
Method_2:
Select C3
From the Excel Main Menu....<edit><copy>
Click and Hold on C3 and paint down as many cells as you need.
Press [Enter] to paste the formula
Note: The cell references will change automatically.
For more info on Relative/Absolute References...
Check Excel Help for: relative
Then select topics about relative references.
Does that help?
Regards,
Ron
Microsoft MVP (Excel)
Bookmarks