Alt key on Mac is indeed exist. And it’s called Option key.

Window users are screwed when it comes to keyboard shortcuts in Excel for Mac. Remember that well. Edit the Active Cell in Excel for Mac. CONTROL+U is the new F2 when you’re using Excel with a Mac. If you want to edit the active cell use the keyboard shortcut CONTROL+U. If you use F2 to edit a cell on a Mac, remember your screwed, and think FU. Although you usually use the Go To feature in Excel 2016 to move the cell cursor to a new cell in the worksheet, you can also use this feature to select a range of cells. When you choose the Go To option from the Find & Select button’s drop-down menu on the Home tab of the Ribbon (or press Ctrl+G or F5), Excel displays a Go To dialog box. Free Excel Crash Course. Learn Go To Special (F5) with CFI’s Free Excel Crash Course.This course gives you the most important spreadsheet formulas, Excel keyboard shortcuts (Mac and PC) Excel Shortcuts PC Mac Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time.

Windows vs Mac—there are so many differences. A lot of our customers have used a PC before and then decide they want to switch to Mac for better performance, nicer design, or for better security. However, they were afraid they would have a hard time getting used to the macOS keyboard. We hear questions like, “How can I close a Window? The Mac keyboard doesn’t have the Alt + F4 shortcut.” We always give them two answers:

1. With Parallels Desktop for Mac you have the choice to use the same keyboard shortcuts you had on your PC.

2. If you want to use the Mac keyboard you will experience that the alt key is very different, as we explain in this blog post.

Where is the Alt key on a Mac keyboard?

The PC-keyboard equivalent of Alt on a Mac is called the Option key, and you’ll find the Option Key on your Mac if you go two keys to the left of the spacebar. However, the option key on a Mac keyboard is used in a different way than the alt key on a Windows PC. In terms of functionality, the alt key in Windows is often more comparable with the Command key than with the Option key on a Mac. You might be also familiar with the Ctrl and Alt keys from your PC. On your Mac keyboard, you have Command (⌘ cmd), Control (ctrl), and Option (⌥ alt) keys.

How do Windows shortcuts change on a Mac?

Check out some equivalents of popular Windows alt shortcuts on a Mac, which might be especially helpful for those users who are new to Mac:

Windows	Mac
Closing a window	Alt-F4	Command-W
Restarting	Control-Alt-Delete	Control-Command-Eject
Shutting down	Control-Alt-Delete	Control-Option-Command-Eject
Logging out	Control-Alt-Delete	Shift-Command-Q
Switch between open apps	Alt + Tab	Command-tab
Go back	Alt + Left arrow	Command + Left arrow
Go forward	Alt + Right arrow	Command + Right arrow
Move up one screen	Alt + Page Up	Command + Page Up
Move down one screen	Alt + Page Down	Command + Page Down

When running Windows on a Mac with Parallels Desktop, is it possible to use Windows shortcuts on a Mac?

If you run Windows on your Mac with Parallels Desktop for Mac, you can configure your keyboard shortcuts the way you want to work, with either macOS or Windows shortcuts. Click here for more information on how to set the different shortcuts.

You can find even more useful Mac shortcuts in the infographic here.

Missing your Start Menu and familiar Windows look and feel? You can use Parallels Desktop and have Windows 10 along with your favorite Windows apps on your new Mac.

Microsoft Excel is huge in terms of its underlying features and functions. So are the keyboard shortcuts in it. The list can go on and on. What we will do is limit our scope and concentrate only on Function Keys today. We will try and learn the actions associated with F1 through F12, standalone and in combination with keys like Alt, Ctrl and Shift.

We all know the basic moves like how you can move around the sheet and select cells using the arrow keys or press Ctrl+A to select the entire worksheet but there are more complicated shortcut keys that you should know.

Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys.

F1

F2

F3

F4

F5

F6

F7

F8

F9

F10

F11

F12

Cool Tip: Did you know that you can just press Esc to expand or collapse the formula bar and Delete to remove cell contents? Well, now you know.

Conclusion

So, did you find the list interesting? If you spend most of your day on Excel, I am betting you must have found it helpful. You may not be able to remember and master all of them but I am sure you will recollect the ones you feel will help you lower your efforts.

Note: These shortcuts have been tried and tested with Microsoft Excel 2013. However, most of them should be downward compatible.

Image Credit: N Hope

See Next: 6 Cool Cell Selection Tips for Microsoft Excel Users
The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.Also See

F5 In Excel For Macs

#function keys #keyboard

F5 In Excel For Mac Shortcut

Did You Know

Only 25% of people can text well without looking at their keyboards.

More in Windows

F5 Excel Macro

Top 3 Fixes for Camera Not Working on Windows 10 PC