Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can't find the keyboard shortcut for this on the mac. It's F2 on a windows machine.

share|improve this question
up vote 40 down vote accepted

Office for Windows: F2
Office for Mac: Ctrl + U

share|improve this answer
1  
Ctrl-U just underlines the text , does not edit it. – javadba May 24 '15 at 23:30
    
That would be command + U – Fuad Saud Jun 15 '15 at 19:42

The problem is that the shortcut has been changed for earlier versions of excel.

F2 used to work on Excel versions before 2011. For the 2011 excel version use ctrl + U instead.

share|improve this answer
1  
I wonder why Microsoft change it? I have been using Windows in work for years, and now I use Mac at home. It would be great if I didn't have to learn a whole new set of shortcuts. (Ctrl-I and Ctrl- for adding and removing rows, for example. Any others? – Victor Grazi Jul 22 '13 at 1:41
1  
I think it's just F- keys, e.g. it's cmd-t instead of F4 to add $ to formulas. I think it's because newer versions of Mac OS do system things with F keys so applications don't know they've been pressed. – user568458 Jan 29 '14 at 17:17

I believe F2 still works, its just that on macs now, to get F2, you need to press fn+F2, otherwise it does the alternative function, which in my mac is to brighten the screen.

share|improve this answer
    
No, in Office 2011, Fn F2 does "cut" as a shortcut. Ctrl+U only lets you start editing in the cell. It does not actually bring you into the Formula Bar (not the Formula Builder, which is something else). – Jon V Nov 21 '15 at 22:49

Excel for Mac 2016: F2

The most recent version of Office for Mac (2016) changed a number of keyboard shortcuts to create greater similarity across Windows and Mac versions of the software. Ctrl + U appears to no longer work as a shortcut key for editing cells in Excel 2016 for Mac. Instead the F2 key must be used. Depending on the keyboard settings on your particular Mac, to trigger F2 (instead of increasing screen brightness), you may have to hold down the "function" key (fn) while also hitting F2. To modify this behavior, go to System Preferences > Keyboard and check or uncheck "Use all F1, F2, etc. keys as standard function keys."

share|improve this answer

Here is the complete list: Shortcuts

share|improve this answer

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

1  
Although this provides an answer to the question, it would be significantly better if you also added the relevant sections from the linked text in the body of your answer. – JMY1000 Mar 13 at 0:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.