What is f4 in excel on a mac

Apr 27, AM. Question: Q: F4 key as an "absolute" function key in excel More Less. Communities Get Support. Sign in Sign in Sign in corporate. Browse Search. Ask a question.

User profile for user: lindasc lindasc. I need my F4 key to be the absolute function in excel. Not working! I have a new imac 3. More Less. Reply I have this question too I have this question too Me too Me too. Helpful answers Drop Down menu. View answer in context. Loading page content. User profile for user: Badunit Badunit. Apr 8, PM in response to lindasc In response to lindasc What do you mean by "be the absolute function"?

Does this mean it inserts the ABS function into the selected cell, changes the selected cell reference from relative to absolute, or what? The Command Y function is not quite the same as redo which the above process outlines how to assign F4 to Redo.

I often use the F4 key Repeat Command in the Windows version to quickly delete rows and columns. I wrote a new post showing how to put the the Repeat command icon on the toolbar, which works even better. What about F2 for editing the contents of a cell? Is there any way to make that happen? There really aren't too many symbols, so I recommend that you bite the bullet and memorize them. The table below shows some example shortcuts with a translation. Like their counterparts in the Windows world, Mac keyboards have function keys.

These keys sit at the top of the keyboard and are labeled F1 to F12 on standard keyboards and F13, F14 and higher on extended keyboards.

Standard Mac keyboard with 12 function keys. As you know, function keys are uses for many shortcuts in Excel. But if you try these shortcuts directly on a Mac, they don't work. By default, Function keys on a Mac control the computer itself, things like screen brightness, volume, video pause and play, and so on. This means that if press only the function keys in Excel, you'll end up controlling the Mac, and not Excel. To make function keys work like you expect in Excel, you need to add a key: the function or fn key.

You'll find the fn key in the lower left on your keyboard. Here are a few examples:. Here you can check a box that will that will change function key behavior to work like "standard function keys".

If you do this, however, note that you won't be able to use function keys for things like Brightness, Volume, etc. In essence, this setting reverses behavior so that you need to use fn to control the Mac. 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.

Unless you're using an extended keyboard, keys like Home, End, backspace, Page up, and Page down are nowhere to be found.