Tech At Hand Dot Net > Random Post > Excel Trick : What is the use of $ sign ?

Excel Trick : What is the use of $ sign ?

Posted by : Dexter Panganiban on September 24, 2007 | ; Filed Under Random Post

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.

Related Posts
Related Posts Plugin for WordPress, Blogger...

search terms:

Tags: Excel

Interesting Comments

Note : All Comment will be subjected to Tech At Hand Dot Net Comment Policy

3 Responses to “Excel Trick : What is the use of $ sign ?”

  1. r0m4n on March 21st, 2008 2:38 am

    thank you very much for this… it saved me today at work ;) i completely forgot how to anchor a formula to a single spot so it doesnt mess everything up when you paste in other places! thanks again!!!!

    r0m4n

    Reply


  2. Dexter on March 21st, 2008 9:54 am

    @ r0m4n,

    Good to know that it helps you

    Dexter’s last blog post..Link Love # 10 :Filipino SEOContest2008 Contenders and Other Good Stuff

    Reply


  3. ALDAIR on October 10th, 2011 11:39 pm

    preciso a formula do cnpj para excel.
    muito obrigado se vc conseguir.

    Reply


3 pingsLinks To This Post

  1. Excel Tip : What If You forget your Excel Sheet Password ? » Tech At Hand on January 17th, 2008 10:01 am

    [...] time to time I am sharing some Tips about Microsoft Excel since I am a heavy user of this program. So here my sharing for today. You can see my other article [...]


  2. Welcome Pacquiao And Marquez Fans » Tech At Hand on March 17th, 2008 5:39 pm

    [...] Excel Trick : What is the use of $ sign ? [...]


  3. How to Unlock forgotten Password in Excel | Tech At Hand Dot Net on August 31st, 2011 12:30 pm

    [...] time to time I am sharing some Tips about Microsoft Excel since I am a heavy user of this program. So here my sharing for today. You can see my other article [...]


Leave a Reply




Helping in Making Money Online and More

Help My Father's Kidney Dialysis Expenses

Help in My Father’s Kidney Dialysis by Contributing Articles and/or Being Our Link Builder

Subscribe to RSS feed

Subscribe to RSS feed

Categories