I want to extend the formula to the WHOLE column. Help please.

  • Follow


Hello, I just want to extend my formula for the whole column, but
dragging down doesn't work. (instead I get the same value as in the
original cell repeated for the whole column).
Any help would be greatly appreciated. Thanks.




-- 
baer
0
Reply baer 12/3/2009 8:03:52 PM

Post the formula. Make sure the cell references do not have dollar signs to 
make them absolute and make sure you calculation is set to automatic or 
maybe use manual calculations and press F9 to calculate

-- 


Regards,


Peo Sjoblom


"baer" <elnara11DONTUSETHIS@yahoo.com.SPAMTRAP> wrote in message 
news:baer.55e200b@excelbanter.com...
>
> Hello, I just want to extend my formula for the whole column, but
> dragging down doesn't work. (instead I get the same value as in the
> original cell repeated for the whole column).
> Any help would be greatly appreciated. Thanks.
>
>
>
>
> -- 
> baer 


0
Reply Peo 12/4/2009 3:57:32 AM


1 Replies
485 Views

(page loaded in 0.64 seconds)


Reply: