Here are some shortcuts to help you format and edit the text of large batches of data. Selection & Navigation Excel Quick Keys Windows Not only can these shortcuts help increase the efficiency of your work, but once you gain an understanding of how to use them they can make simple Excel tasks that much easier. Here are some shortcuts to help you select and navigate large batches of data. Paste Special *The following Paste Special shortcuts will also work with either of the listed Windows shortcuts, simply replace the first three actions with either version.* Basics & General Shortcuts For Excel Modeling Windows Creating macros is covered further down in the article. If you find yourself frequenting a shortcut or action multiple times try creating a macro for this task. Mastering these will pave the way for your future success as well as an understanding of the more complex and complicated shortcuts. Listed below is a brief list of some of the most common shortcuts that you will encounter when using Excel. This displayed tooltip does not appear for all actions, just the more frequently used ones such as 'Ctrl + S'.īelow is a reference image for Macs of the shortcut next to its respective action.īasics & General Shortcuts For Excel Modeling

The process is similar for a Windows user, except that the shortcuts are displayed when you leave your mouse cursor hovered over the desired action. If you have trouble remembering the shortcuts on Mac, you can open the menus at the top of the screen and see the keyboard combinations listed next to the corresponding action. It is also easier to find more information about shortcuts for Windows than Mac.

Please note that not every Windows shortcut has a duplicate Mac shortcut to complement it. Useful Excel Quick Keys for Windows & Mac To buy a copy of Excel or to learn more about this service, check it out here. If you have any more FAQs on Excel or Microsoft 365, refer to this FAQ page. This '/' functions as an ' OR' and serves to show that either button or task will work depending on the situation. You may also see some shortcuts or shortcut tasks with a '/' listed between buttons or tasks. A ' +' means that you would press the key before AND after it at the same time while a ' ,' means that you press the button after it in sequence. This means that you would press Alt AND H at the same time. The process for a Mac would be slightly different as you would have to press Cmd (Command, or the button next to the spacebar) AND C at the same time.įor some of the more complicated shortcuts, we will have them listed as: This format means that you would press Ctrl (Control, or the button in the corner of your keyboard) AND C at the same time. One of the most common and well-known shortcuts is:

Common mac keyboard shortcuts printout