mac microsoft excel keyboard shortcuts cheat sheet

Turn the screen black while in presentation mode Option + Page Down or Fn + Option + Down Arrow Option + Page Up or Fn + Option + Up Arrow

Move to the last cell in use on the sheet Move between unlocked cells on a protected worksheet Select only the active cell when multiple cells are selected Microsoft Outlook - Flagging Messages, Tasks, and Contacts Switch the calendar view to include today Open the selected event, note, task, or contactĭelete the selected event, note, task, or contact Microsoft Outlook - Calendar, Notes, Tasks, and Contacts Once you’ve read the article and you understand what each shortcut does, spend two or three minutes per day practicing until you know them by heart.Ctrl + Tab I will go through each of these in detail but to learn them faster, start by printing the commands out or writing them down. Luckily, after spending thousands upon thousands of hours in Excel I’ve narrowed down the field to the most valuable ones on your behalf. It would be great to memorize all of those shortcuts but for most people that isn’t feasible. This lets you keep your focus where it belongs - on the problem you’re trying to solve.Įxcel is designed for power users, and as a result, there are hundreds of delectable keyboard shortcuts that you could learn (especially on Windows).

Using shortcuts allows you to outsource functions like copy and paste from your conscious mind (using a mouse) to your unconscious mind (muscle memory). Much like graduating from hunt and peck to touch typing, using keyboard shortcuts frees up your brain from the distraction of target acquisition. 12 keyboard shortcuts that will make you better at ExcelĪsk a software developer, banker, writer, or really anyone who types professionally and they will sing the praises of keyboard shortcuts.

Mac microsoft excel keyboard shortcuts cheat sheet