software

I'm creating a simple spread sheet in Excel. I want to, throughout the
sheet, subtract Coumn C from Column B and have the result shown in Column D
without placing the formula in each cell for each entry... HELP!

In you mean quot;type the formulaquot; in each cell, you can use the fill handle by
grabbing the lower right corner of the cell and dragging down.

If you mean you don't want a formula unless there is data to calculate, you
need a macro.

--
Don Guillett
SalesAid Software

quot;Jan in Excelquot; lt;Jan in gt; wrote in message
...
gt; I'm creating a simple spread sheet in Excel. I want to, throughout the
gt; sheet, subtract Coumn C from Column B and have the result shown in Column
gt; D
gt; without placing the formula in each cell for each entry... HELP!
Hi Jan,
You don't have to key in formulas in each cell. Just select the row
including the top cell in which you have place the formula, and click quot;Cntrl
Dquot;
Voila!!
--
Sudhirquot;Jan in Excelquot; wrote:

gt; I'm creating a simple spread sheet in Excel. I want to, throughout the
gt; sheet, subtract Coumn C from Column B and have the result shown in Column D
gt; without placing the formula in each cell for each entry... HELP!