Apply title case ("proper case") to an entire spreadsheet?
Solution 1:
Not really an excel solution, but fast.
[ Select All(in excel) , copy > paste in Notepad++
| Select all(in notepad++) > Edit >Convert Case to > Proper Case
| Select All(in notepad++) , copy > paste in excel ]