That’s the list of my favourite shortcuts in Excel. Highlight from the current cell to the last cell containing data Highlight from the current cell back to cell A1 Highlight from the current cell back to column A of the row Move the cursor to last cell containing data Scroll the mouse wheel up to zoom in and down to zoom out My Favourite Shortcut Keys Shortcut Keysįind text or formatting within the current workbookįind and replace text or formatting within the current workbook Don’t worry about writing these ones down, you can receive a PDF copy of all keyboard shortcut lists at the bottom of this post. Once you have those locked into memory then identify the next group and continue until you have mastered shortcuts like a pro!īelow is a list of my favourite shortcuts to use in Microsoft Excel. Break them down into a hand full of the shortcuts you think you will use most often. Don’t try to memorise them all in one go. If you plan to start using keyboard shortcuts, start small. Because I often multi-task on the computer, I tend to use many of these shortcut keys on a very regular basis. Anything that can improve efficiency and workflow is a good thing in my books.

Anyone who has ever attended training with me, or even anyone who has read my other “shortcut key” posts, should know that I am a big fan of shortcuts.

Want to become more efficient using Excel? Let me show you the best keyboard shortcuts in Excel.

Key shortcuts for excel 2016