| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a Formula for entire column?
I can't figure out how to set a Formula for an entire column. If I want
Column F to represent Column C plus Column D minus Column E, what do I enter? (Not just for one row, the whole sheet) Many thanks! Gary |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a Formula for entire column?
Click on the F of column F's header
Type =C1+D1-C1 Press CTRL+ENTER (If you press CTRL+SHIFT+ENTER you will make an array formula; the results will be the same but you will not be able to alter any single cell in the column) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Gary" wrote in message ... I can't figure out how to set a Formula for an entire column. If I want Column F to represent Column C plus Column D minus Column E, what do I enter? (Not just for one row, the whole sheet) Many thanks! Gary |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a Formula for entire column?
In some cell in column F:
=SUM(C:C)+SUM(D:D)-SUM(E:E) "Gary" wrote: I can't figure out how to set a Formula for an entire column. If I want Column F to represent Column C plus Column D minus Column E, what do I enter? (Not just for one row, the whole sheet) Many thanks! Gary |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a Formula for entire column?
Wonder which one of us correctly read the OP's question!
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... In some cell in column F: =SUM(C:C)+SUM(D:D)-SUM(E:E) "Gary" wrote: I can't figure out how to set a Formula for an entire column. If I want Column F to represent Column C plus Column D minus Column E, what do I enter? (Not just for one row, the whole sheet) Many thanks! Gary |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a Formula for entire column?
Hopefully one of us did. Goes like that around here at times: one person
reads the question one way, someone else in another. Someone gets to be right - and that's good for the OP. "Bernard Liengme" wrote: Wonder which one of us correctly read the OP's question! -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... In some cell in column F: =SUM(C:C)+SUM(D:D)-SUM(E:E) "Gary" wrote: I can't figure out how to set a Formula for an entire column. If I want Column F to represent Column C plus Column D minus Column E, what do I enter? (Not just for one row, the whole sheet) Many thanks! Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling a formula in entire column | Excel Discussion (Misc queries) | |||
| How to apply the same formula to an entire column | New Users to Excel | |||
| enter formula once for entire column | Excel Worksheet Functions | |||
| Enter Comment for an Entire Column | Excel Worksheet Functions | |||
| how can i fix one entire column after putting my formula there so. | Excel Worksheet Functions | |||
Linear Mode
