F4 and F9 keys EXCEL MAC
Solved
aboudeh_01
-
Aliboron Martin Posted messages 3655 Registration date Status Contributeur Last intervention -
Aliboron Martin Posted messages 3655 Registration date Status Contributeur Last intervention -
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 :)
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 :)
5 réponses
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
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
aboudeh_01
Thank you for your response regarding the order-T; it works perfectly, but to start the calculations, which is "order-+", I actually need to use the SHIFT key, which means SHIFT(=) gives me +, so it doesn't work. Do you have any ideas for another command or how I should proceed for this function?
