| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm creating a simple spread sheet
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm creating a simple spread sheet
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. -- Don Guillett SalesAid Software "Jan in Excel" <Jan in wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I'm creating a simple spread sheet
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!! -- Sudhir "Jan in Excel" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spread sheet not printing correctly | Excel Discussion (Misc queries) | |||
| print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
| How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| How do I create a spread sheet w/a numerator/denomenator? | Excel Discussion (Misc queries) | |||
Linear Mode
