F4 and F9 keys EXCEL MAC Solved

Question

Hello,  I am using Microsoft Office Excel 2008 for Mac and I wanted to know how to use the F4 key for the $$ and F9 for the RAND function  Thank you in advance :)

Bernard Rey · Accepted Answer

aboudeh_01 :  I use Microsoft Office Excel 2008 for Mac and I wanted to know how to use the F4 key for the $$ and F9 for the RAND function.  You're talking about functions on Windows machines. You need to detoxify yourself ;-)  - In the Mac versions of Excel, F4 is "Paste text in the active cell" and switching between relative and absolute references is "Command-T", in Excel 2008 just like the others.  - The F9 key triggers calculation on all sheets, which isn't really that interesting nowadays. But, if you ever need to, you can also do this with the shortcut "Command-=" (the equal sign).  If your function keys aren't active like you'd want them to be, that's something you can adjust in the system preferences (the precise settings vary depending on the keyboard used and also the version of Mac OS X).  [Update] I corrected the shortcut for manual calculation, which I copied too quickly from the Excel help.   Hello to you! Bernard

dede74000 · Answer

Hello,

You just need to go to the Apple menu/System Preferences/Keyboard and Mouse/Keyboard Shortcuts and assign the keys to what you want to do, by specifying the path or adding additional function keys with the plus sign (+).
--
"There's no need to rush; just arrive."

[ Henri Dreysse ]

Bernard Rey · Answer

Ayala :  I need to use what PCs do with the F9 key. But on my Mac, it doesn’t work. .../... I tried, as I read somewhere, Command and + but that doesn’t do anything either.   I don’t really understand why you switch to manual calculation instead of auto, but anyway. At my place, manual calculation works fine with the shortcut "Command =" (the equal sign)  Note: I corrected my first message where I incorrectly stated the shortcut!   -- Hello to you! Bernard

Bernard Rey · Answer

Madrox :  I am looking for the keyboard shortcut to enter a cell in Excel for Mac. On PC, we use the "F2" key. But I can't find the shortcut on Mac.   I'm not able to check at the moment, but if I remember correctly, it's "Command-U" that is the shortcut in question.  You don't specify which version of Excel you're using. If you're using a version that has VBA, you can set it up to achieve the same effect with the F2 key by looking at the instructions provided by JE McGimpsey on his page (just be careful not to conflict with existing shortcuts)   -- Hello to you! Bernard

tchava · Answer

Hello,

When I import an Excel table from the web, there are spaces in each cell. On PC, I can use find and replace. However, on Mac, they are not recognized as spaces, so I can't easily remove them...

Thank you in advance.

F4 and F9 keys EXCEL MAC

5 answers

Caution: redirects at spartoo (300 eur)

Unrecognized product information

How to back out with cdiscount

No access to my ubisoft account

Thunderbird password connection not possible

Antivirus problem

Unable to scan

Wrong keystrokes

I wanted to turn on my windows pc but i lost my product key

Latine reddere titulum.