Did you know “$” sign is an important part of excel formula? I would try to teach how you could use this sign.
Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 )
Answer : You can do it by placing the cursor inside the formula at the desired cell reference and press F4, In the figure below at Cell reference C1Â with an original formula of ( =+B1*A1 )it has been change to ( =+B1*$A1$ ) in order to fix the pick at Cell A1.
How to do this?
Go to cell C1 and point your cursor to A1 ( =B1*A1 ) Then pres F4. Then you can just copy and paste anywhere in the sheet and it will still link to A1. You can do a horizontal and Vertical Copy.
When “$” sign is at the right side it will just collect fix at A1 if you will copy and paste in vertical ( up or down )
When “$” sign is at the right side it will just collect fix at A1 if you will copy and paste in horizontal ( left or right )
You can manually change the dollar sign position. However you could also press F4 to change dollar location.