In one of the videos of the Excel Introduction Course the teacher typed in a formula without fixed references and then instantly fixed them. How did he do that?
A Useful Tool for Financial Analysis – The Rank Function
Time 1:30 min
Does anyone know what is the trick here?
Thanks for reaching out!
All you need to do is press F4 once or twice – this is the shortcut for fixing cell references. If you press it one time, you’ll fix both references, and if you press F4 two times, you’ll fix the row reference only.
All the best,
Thank you Ned!
And just googled that on Mac it is fn+F4.
Problem solved 🙂