Formulate a Column ?

Hey all,
How can I keep a cell formula, for the entire column??

At the moment I have to copy/paste the previous cell, to get a calc !!
What am I missing.....or cant Excel do it?

Home = Office97
Work = Office 2003?

NT.

In Tools|Options|Calculation is "Manual" checked?

Jerry

NT_eyeball wrote:

> Hey all,
> How can I keep a cell formula, for the entire column??
>
> At the moment I have to copy/paste the previous cell, to get a calc !!
> What am I missing.....or cant Excel do it?
>
> Home = Office97
> Work = Office 2003?
>
> NT.

Highlight the cell with the formula
Hold down the shift key and hit the down arrow or page down to a point you
want it to stop then take fingers off the keyboard...hold down the control
key and tap the letter d


"NT_eyeball" wrote:

>
> Hey all,
> How can I keep a cell formula, for the entire column??
>
> At the moment I have to copy/paste the previous cell, to get a calc !!
> What am I missing.....or cant Excel do it?
>
> Home = Office97
> Work = Office 2003?
>
> NT.
>
>
> --
> NT_eyeball
> ------------------------------------------------------------------------
> NT_eyeball's Profile: http://www.excelforum.com/member.php...o&userid=26292
> View this thread: http://www.excelforum.com/showthread...hreadid=395749
>
>