ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   I want to extend the formula to the WHOLE column. Help please. (https://www.excelbanter.com/new-users-excel/250042-i-want-extend-formula-whole-column-help-please.html)

baer

I want to extend the formula to the WHOLE column. Help please.
 
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.

Peo Sjoblom[_3_]

I want to extend the formula to the WHOLE column. Help please.
 
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" wrote in message
...

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





All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com