@excelcampus: What's your least favorite Excel shortcut? Mine is probably Ctrl+Shift+3. This shortcut applies date formatting to cells. And you might be wondering why anyone would hate on that. 🙂 It's because I rarely use the date format (d-mmm-yy) that Ctrl+Shift+3 applies. Today's date would be formatted as 1-Aug-23. In the video, I share some alternative shortcuts that apply a more commonly used date format, mm/dd/yyyy or dd/mm/yyyy, depending on your region. The shortcuts are: Alt, H, N, S, Enter (Windows only and the key sequence will might different if you are on a non-English version of Excel) Ctrl+1, Tab, D, Enters (Windows or Mac) #Excel #ExcelCampus #LearnOnTikTok #ExcelShortcuts2023 #ShortcutHacks #ExcelShortcuts101 #ExcelShortcutsPro #QuickExcelTips

Jon Acampora Microsoft MVP

Open In TikTok:

Region: PH

Friday 04 August 2023 16:52:06 GMT