Last answered:

09 Sept 2021

Posted on:

01 Aug 2020

0

F5+ENTER

SIR,I HAVE FOLLOWED ACCORDINGLY BUT THIS SHORTCUT IS NOT WORKING...KINDLY LOOK INTO IT
4 answers ( 0 marked as helpful)
Instructor
Posted on:

04 Aug 2020

0
Hi Mohd! Thanks for reaching out. Can you please show us the formula written in the relevant code cells, so that we can explore if the references are correct? In the meantime, please double-check that you have un-ticked Allow editing directly in cells from File/Excel Options/Advanced. Thank you. Hope this helps.
Best,
Martin
Posted on:

20 Nov 2020

0
I am using a Mac, and every time I hit F5 (fn+F5) a 'GO TO' box pops up. I am also unable to find the options tabs that this references many times. I have gone into the Excel drop down at the top and gone to preferences and it's not there either. I have Googled it and it said to go to the Preferences>View tabs and I have done that as well and am still unable to find the exact box to 'uncheck'. Thank you. krystalplre@gmail.com
Instructor
Posted on:

22 Nov 2020

0
Hi Krystal! Thanks for reaching out. Can you please support your question with a screenshot(s)? I.e. what do you mean that you are unable to "find the options tabs" - that the Go To window that popped up contained no options? In that case, had you completed the operations suggested earlier in the lecture? Looking forward to your answer.
Best,
Martin
Posted on:

09 Sept 2021

0

There is no options tab under file for Mac Excel. I am facing the same problem.

Submit an answer