I'm creating a simple spread sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 "type the formula" 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.
 
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 "Cntrl
+ D"
Voila!!
 
You must log in or register to reply here.

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

Similar Threads

Excel Monthly Spread sheet. 12
Formatting rows in a spread sheet. 8
Change all text on Spread sheet 1
Linking Spread Sheets 1
problem with fractions to decimal 1
Resizing cells within the same spread sheet 2
add or subtract every 5th column 2
Need formula to add cells with same group 1

Back
Top