hi Niek, i have that selected already. i just dont know how to write out the
formula for a divide function for a whole column. lets say the formula starts
in D6, how would that be written out.

"Niek Otten" wrote:

Try this:

ToolsOptionsEdit tab, check Extend data range formats and formulas

Do read HELP to understand how and under which conditions it works

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"YMC" wrote in message ...
|i am having some trouble adding a math function to a whole column, i know how
| to add math functions to cells but in this situation i do not know the amount
| of cells there could be. ther could be 10 or 10000 cells with information in
| them, i need to divide by 60 to a whole column. how would i go about doing
| this. thankyou in advance,