You can Fix the Stupid CAPS Ribbon
The Spreadsheet Page Blog: Office 2013 RIBBON TABS
It works too and looks so much more civilized than the shout fest that it is by default.
Just go to the Customize Ribbon section of the Excel Options dialog box. Select a tab name and click Rename. Type your new name, using any mix of upper and lower case character. Butů If the name is the same as the original tab name, it will revert to uppercase.
The trick: Just add a space character to the end of the name. Here's an example. The HOME tab has been renamed Home<space>.