The shortcut to toggle absolute and relative references is F4 in Windows, and Command T on a Mac.įor a complete list of shortcuts, see our side-by-side list on the Exceljet website.
#Mac shortcut for excel to reduce digits mac
There is no equivalent on the Mac.įinally, the fifth difference on a Mac is that some Excel shortcuts are just different.įor example, the shortcut for Edit Cell, in Windows is F2 and on a Mac, it's Control + U. Ribbon shortcuts on Windows are based on so called accelerator keys, and always begin with Alt. The fourth difference on Macs is the lack of ribbon shortcuts. If you're using an extended keyboard on a Mac, you don't need to worry about this. But, once you understand the substitutions, the shortcut make more sense. This can make certain shortcuts seem complicated on a Mac, because you need to use substitutions for these keys. Personally, I like using the function keys to control the computer, so I leave this setting alone, and just the fn key when needed in Excel.Ī third difference on Macs is that certain keys like Home, End, backspace, page up, and page down, and so on, are missing, unless you're using an extended keyboard. You can actually change this behavior, by unchecking a checkbox under System Preferences.īut, if you do this, you won't be able to use function keys for things like Brightness, unless you hold down the fn key. So, for example, to use the F9 key to evaluate a formula, you'll need to use fn + F9 You'll find this key in the lower left on your keyboard. To make function keys operate as you expect in Excel, you need to hold the function or fn key. Second, function keys behave differently on a Mac.įunction keys sit at the top of the keyboard and are labeled F1 to F12 on standard keyboards and F1 to F15 on extended keyboards.īy default, Function keys on a Mac control the computer itself, things like screen brightness, volume, video pause and play, and so on. On a Mac, you'll see these symbols in menus across all applications, so they're not specific to Excel.
Here's a list of those symbols and the keys they represent.
/cdn.vox-cdn.com/uploads/chorus_image/image/67768467/NewMacBookAir_Keyboard.0.jpeg "mac shortcut for excel to reduce digits")
Here are the 5 key differences you need to be aware of.įirst, many shortcut keys on the Mac are often abbreviated as symbols. But it may not feel that way, especially if you come from a Windows background. In general, Excel shortcuts on the Mac are more similar than different from Windows shortcuts.
In this video, we'll talk about using Excel shortcuts on the Mac.
0 kommentar(er)
