How to press f4 on mac excel

Thank you again so much! What about using F4 to lock cells i.

Function F4 in Excel for Mac OSX

Or use the Switch Reference on the Formulas tab of the Ribbon. I would like F4 to act as in Windows Excel for cycling on reference types, but I cannot find the appropriate command in the dialog box for keyboard customisation.

Related posts: This doesn't matter much when you're performing an action that has a dedicated shortcut i. But when you want to trigger an action that doesn't have a dedicated shortcut like sort, hide gridlines, align text, etc.

Post navigation

Excel ribbon in Windows with accelerator keys visible. No equivalent on the Mac! With the introduction of Excel on the Mac, Microsoft has started to adjust Mac shortcuts to be more aligned with Windows. So far, all the shortcuts that have been adjusted to match Windows shortcuts remain backward compatible with previous Mac only shortcuts.

Helpful answers

Skip to main content. Excel shortcuts on the Mac by Dave Bruns March 23, Also see: If you want to see more Excel shortcuts for the Mac in action, see our our video tips.

Download 200+ Excel Shortcuts

Whenever we use a shortcut, we show both the Windows and Mac version. I thoroughly enjoy watching the videos you provide on your website Your videos make learning featres in Excel easier than reading instructions.


  1. What is Mac equivalent of the F4 shortcut that converts cell - Microsoft Community;
  2. How to Use Microsoft Excel. Learn Online..
  3. about mac os operating systems!
  4. In this topic;
  5. uninstall mac adobe reader 9;
  6. Toggle absolute and relative references?

Being able to see something demonstrated makes all the difference. Excel video training Quick, clean, and to the point.

Excel shortcuts on the Mac

If you're looking for a keyboard shortcut to toggle between absolute and relative references in Numbers 3, you can click the range token in a formula and hit command-k and shift-command-k. Me too. Jan 15, 2: Jan 15, 3: Apr 27, 8: F4 key as an "absolute" function key in excel More Less. Communities Contact Support. Sign in.


  1. Keyboard shortcuts in Excel for Mac?
  2. Keyboard shortcuts in Excel for Mac - Excel for Mac.
  3. make an exact copy of my hard drive mac.

Browse Search. Ask a question.

macos - Method for using F4 key without pressing function button on MacBook Pro - Ask Different

User profile for user: F4 key as an "absolute" function key in excel Can anyone help. I need my F4 key to be the absolute function in excel.

Microsoft Excel create a mixed reference - F4 key to change references by Chris Menard

Not working! I have a new imac 3.