I am desperately trying to create a formula for an entire column. I would
like to be able to click on the column or row and have a formula that
automatically applies to every value in that column or row without having to
worry about the auto-function disappearing when I skip a row to enter text.
Any help?!! PLEASE!!!

hi, !

I am desperately trying to create a formula for an entire column.
I would like to be able to click on the column or row and have a formula
that automatically applies to every value in that column or row without
having to worry about the auto-function disappearing when I skip a row to enter text...

while you are entering or modifying your formula, try toggling {F2} key
and check over the status bar: if it reads "edit...", yu are navigating within the formula
otherwise, you are selecting/navigating references on the worksheet

hth,
hector.