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