F5+ENTER
SIR,I HAVE FOLLOWED ACCORDINGLY BUT THIS SHORTCUT IS NOT WORKING...KINDLY LOOK INTO IT
4 answers ( 0 marked as helpful)
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
Best,
Martin
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
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
Best,
Martin
There is no options tab under file for Mac Excel. I am facing the same problem.