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)?

Back to all questions

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

6 days ago
Vote Up Vote Down
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 5 days ago
Vote Up Vote Down
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

4 days ago
Vote Up Vote Down
0
Votes

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

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #, #, #, #.

JanuaryPromo
×
Complete Data Science Education
Get 50% OFF