View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default Copying formulas to end of Column

Hi,

Try this:

select the cell you wish to copy down then hold the Shift+Ctrl and hit the
down arrow key to select the rest of the column, next hit the F2 key to go
into the edit mode then hold the Ctrl key and hit Enter.

HTH
Jean-Guy

"kippers" wrote:

Hi,

Quick question- how can I quickly copy a formula to the end of an entire
column (without having to scroll all the way down)??

Cheers,