Follow this topic

Last answered:

15 Oct 2022

Posted on:

11 Nov 2021

1

Hi. Are you using some key combination to put the $ sign in your formula?

in Introduction to Excel / A Useful Tool for Financial Analysis - The Rank Function

I can see you are putting them all at once and was wondering if you are editing the video or use some key combination?

2 answers ( 0 marked as helpful)

Rajesh Ravanappan

Posted on:

07 Dec 2021

0

Same doubt, even searched in Google for that ..

Mohd Fairuz Bin Amir Nazarullah

Posted on:

15 Oct 2022

6

Press F4 once to fix the column and row, press F4 twice to fix the row only and press F4 three times to fix the column only.

Submit an answer

related questions

Mario Contreras

1

12

Why are we using SUMIF to transfer data instead of using VLOOKUP?

Panagiotis Blatsas

0

8

Resolved: How do the Xs help you go faster to the bottom of your sheet as you say?

0

6

Using Free Online version of Excel to Create a Bridge Chart

Obioha Chijioke

0

6

Using x's in excel to speed up copy and paste.

Mohammad Abdullah Ansari

0

6

Resolved: How did you select all the table rows and columns in one click?

0

6

How did you quickly select the B column around 50 seconds?

Panagiotis Blatsas

0

6

Index and Match exercise tried the exact formula yet all results are N/A?

Mohammad Abdullah Ansari

2

4

Resolved: Alt combination key is not working for Mac