The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

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

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

0
Votes
2
Answer

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://365datascience.teachable.com/courses/526364/lectures/9600892 
Video title:

A Useful Tool for Financial Analysis – The Rank Function

Time 1:30 min
 
Does anyone know what is the trick here?
 

2 Answers

365 Team
0
Votes

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

0
Votes

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

JanuaryPromo
×
Complete Data Science Education
Get 50% OFF