How do I enter a Formula for entire column?

G

Guest

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
 
B

Bernard Liengme

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
 
G

Guest

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.
 

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 Subtracting multiple columns from another column 3
How do assign formulas to an entire column? 2
Figuring out a lengthy formula. Probably quite simple... 3
Copying formulas across columns 2
need formula: # entered in column B will transfer to column D 5
Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1
compare 2 columns, enter data from other column 1

Top