Note: Assigning this shortcut to a macro would be a potential workaround. Please leave a comment below if you do know how to change the default date format for Ctrl+Shift+3. It's unfortunate because this is NOT a date format I use very often. I don't know of any way to change the shortcut to apply a different date format. This shortcut uses the day-abbreviate month-year format. Date Format ShortcutĬtrl+Shift+3 is the shortcut to apply the Date format. Checkout my article on the date system for Excel to learn more about date & time data types. The Time format displays hours:minutes and AM/PM at the end. Time Format ShortcutĬtrl+Shift+2 is the shortcut to apply the Time format. The characters used for the separator will depend on your locale settings in Windows. The Number format has a separator for thousands, millions, etc.

Number Format ShortcutĬtrl+Shift+1 is the shortcut to apply the standard Number format. If the cell contains a number then it displays raw numbers without any comma separators, currency/percentage symbols, etc. General is the default number format for all cells on a blank sheet. You can use the General Number Format ShortcutĬtrl+Shift+~ is the shortcut to apply the General format. The shortcuts work on both the Windows and Mac versions of Excel. The format will be applied to the selected cell(s). Then press one of the number keys at the top of the keyboard.This might make it easier to use two hands to press the combination. However, you can also use the Ctrl & Shift keys on the right side of the keyboard. The diagram shows the Ctrl & Shift keys on the left side. Here is a quick guide that explains what each shortcut does. The Ctrl+Shift+Number Key shortcuts allow us to quickly apply some of the most popular number formatting options including: currency, percent, number, date, and time. If you spend a lot of time formatting numbers in Excel (who doesn't?) then you will love these shortcuts. No platform confusion, no unintelligible symbols - just a clear list of shortcuts to make you Download Number Format Shortcuts Guide To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. But often, it can be hard to remember these hotkeys - especially if you regularly switch between the Mac and PC versions of Excel. Excel shortcut keysĮxcel shortcut keys can greatly improve your speed when conducting analysis. By submitting this information, you agree to Deskbright's privacy policy and terms of service.

Excel shortcut keys capital letters