How do I enter a Formula for entire column?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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.
 
Back
Top