To see a full list of all shortcuts available in Excel, use the F1 key to access the built-in Microsoft Excel Help feature and search for keyboard shortcuts.īe sure to check out my other posts for keyboard shortcuts to use in Microsoft OneNote, Outlook, PowerPoint and Word, 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
#Keyboard shortcut for highlighting cells in excel pdf
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.