Depends what you mean by a 'whole' worksheet.

To change a column of text values to proper, insert a blank column adjacent
to the one iwth the text values. Say the text values are in A, and you've
inserted a new, empty B column

Use this formula in B1 and copy it down as needed

=PROPER(A1)

Now select all the formula values and Edit-Copy
Select all the original values in A and Edit-Paste Special-Values
Delete column B



"peter" wrote:

how do i change a full excel sheet to proper after it has been typed
see i have typed up a spreed sheet but as i have realized the first string
is still in lower case is there a way to change the whole work sheet at once