Click the Office button. Click Excel Options.

Click Proofing.
Click AutoCorrect Options.

Click the AutoCorrect tab.
Select the Show AutoCorrect Options buttons to display the button to change AutoCorrect option when corrections arise.

Select the Replace Text As You Type.

Select the capitalization related check boxes for AutoCorrect.

To change AutoCorrect exceptions, click Exceptions

Click the First Letter or INitial CAps tab

Then click OK.
