I need to apply the PROPER function to an entire worksheet that has a few
thousand cell entries. I have two problems in accomplishing this:
First, I can't format more than one column- and I'm only able to that using
the fill-handle. For some reason, trying to do this as a traditional
function like this: =proper(cell:cell), is not working.
Second, I end up with two sets of data- one formatted and one not. I need
the function to be 'underneath' the data.
Is there a way to write one function for the entire worksheet, and have it
applied to the entire worksheet and not as a new set of data?

Appreciate any help,

Danielle