If you would like a printable copy of all my favourite keyboard shortcuts, simply subscribe to our newsletter below and a copy will be emailed to you. I love hearing about shortcut combinations that other people use so feel free to comment below if you have a favourite combination not listed here. 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 If you have to press a key right after another key, the keys will be separated by a comma (,). If a shortcut requires pressing two keys or multiple keys at the same time, the keys are separated by a plus sign (+). Move the cursor to last cell containing data Today, we will give you the sequel to keyboard shortcuts for Excel 2016. 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.
0 Comments
Leave a Reply. |