Make your fingers learn the shortcut keys.Replace your 10 most used options with shortcuts.If not, I believe holding Fn and Down arrow does the PageDown, so, you’d use. Mac Users: depending on your keyboard, you may or may not have a PageDown button. To create the bullet point shortcut on a PC. Ctrl and PageUp activates the previous worksheet. Think of it as the alternative to the asterisk (which lives on the 8 key on most keyboards). For example: Ctrl + A, you can press left. The left and right side key on the keyboard perform the same function. For example: Alt + H, H means: Press and hold the Alt key and whilst holding it down, press and release the H key, then press and release the H key. Tips to make best out of this shortcut cheat sheet When you press and hold the Ctrl key, and then hit the PageDown button, Excel activates the next worksheet. A comma sign (,) in a shortcut means that you need to press multiple keys in order. Finally, some Excel shortcuts are just plain different.
#EXCEL SHORTCUTS ON A MAC USING ALT KEY MAC#
No equivalent on the Mac! Note: Accelerator Keys is a commercial product that makes it possible to drive the ribbon with the Alt/Option key using Accessibility features on Mac OS.
#EXCEL SHORTCUTS ON A MAC USING ALT KEY WINDOWS#
Excel ribbon in Windows with accelerator keys visible. When you press the ALT key Excel shows you the keys that you can use to open the tab from the ribbon.Īnd when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further drop-downs. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find. That's why I have listed only 82 most important keyboard shortcuts that you can learn and use easily. There are more than 500 keyboard shortcuts that you can use in Excel but the problem is not all of those can be helpful for you. Likewise, the Windows keyboard's Alt key is where you expect to find the Mac's Command key. If you're a long-time Mac user transitioning to a Windows keyboard, the Windows key, which is equivalent to the Mac's Command key, may occupy the physical position of the Option key on a Mac keyboard. Knowing and using Keyboard Shortcuts while using Excel is one of those Basic Excel Skills that can help you save a ton of time every day.Ĭommand Windows Mac Fit image on screen: Ctrl + 0: Command + 0: Zoom in: Ctrl + Command + Zoom out: Ctrl – Command – View / Hide extras: Ctrl + H: Command + H: Drag image with Hand Tool: Spacebar drag: Spacebar drag: Fit image in window: Double click Hand Tool: Double click Hand Tool: Rotate file: Press and hold R and use stylus. Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019