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: In other words, please don't do that for your own sanity! Most common Excel shortcuts Learning the shortcuts in Mac is like learning to play the Banjo (5 strings) when you are training to be a lead guitarist (6 strings) for a famous rock band.

and going home at 3:00 A.M.Īlthough we include the shortcuts for Apple/Mac on this page, if you plan to work in investment banking or another high finance career, we strongly recommend that you purchase a PC keyboard and use parallels on your Mac to mimic a PC environment since you almost certainly will be using a PC for your work computer. Often in finance careers, knowing the quick keys and shortcuts in Excel can be the difference between going home at 11:00 P.M. It can initially seem hard to use shortcuts if you have been accustomed to working with the mouse, but learning these shortcuts will eventually save you a tremendous amount of time in the long run by making you more proficient in Excel.

Ms excel shortcut keys ppt