MS Excel Formatting Without The Mouse

MS Excel Formatting Without The Mouse

I thought today might be a good time for an installment of keyboard shortcuts...

In MS Excel:

• Ctrl + Shift + ~ will apply the General Number format to the currently selected cell(s).
• Ctrl + Shift + $ will apply the Currency format, with 2 decimal places and negative values in parentheses, to the currently selected cell(s).
• Ctrl + Shift + % will apply the Percentage format, with no decimal places, to the currently selected cell(s).
• Ctrl + Shift + ^ will apply the Exponential Number format, with 2 decimal places, to the currently selected cell(s).
• Ctrl + Shift + ! will apply the Number format, with 2 decimal places, commas for 1000 separators and - for negative values, to the currently selected cell(s).

• Ctrl + Shift + & will apply the Outline Border to the currently selected cell(s).
• Ctrl + Shift + _ (underscore) will remove the Outline Border to the currently selected cell(s).

• Ctrl + B will toggle to apply or remove Bold formatting to the currently selected cell(s).
• Ctrl + I will toggle to apply or remove Italic formatting to the currently selected cell(s).
• Ctrl + U will toggle to apply or remove Underline formatting to the currently selected cell(s).
• Ctrl + 5 will toggle to apply or remove Strikethrough formatting to the currently selected cell(s).

Well, we'll call it good for today. That seems like quite enough to absorb for now.

Combine these with the keyboard techniques for highlighting (shift key with arrows and other movement keys) and you've got a recipe for mouse-free Excel days!