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? Video: https://learn.365datascience.com/courses/introduction-to-microsoft-excel/a-useful-tool-for-financial-analysis-the-rank-function Video title: A Useful Tool for Financial Analysis - The Rank Function Time 1:30 min Does anyone know what is the trick here?

Hi Milena, 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, Ned

Thank you Ned! And just googled that on Mac it is fn+F4. Problem solved :-)

Follow this topic

Milena Dziebaj

Last answered:

12 Jan 2021

Posted on:

10 Jan 2021

How to fix references in Excel all at once (not typing in $ one by one)?

2 answers ( 0 marked as helpful)

Ned Krastev

Posted on:

11 Jan 2021

Milena Dziebaj

Posted on:

12 Jan 2021

How to fix references in Excel all at once (not typing in $ one by one)?

Submit an answer