Excel Trick : What is the use of $ sign?

Did you know “$” sign is an important part of 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 )

See it here

Related Topics :

Excel Tricks : Hide Those %&@# Formula Errors

How to join Excel data in Cell

Site Search Tags: , ,

3 thoughts on “Excel Trick : What is the use of $ sign?

  1. hey!
    thanks for your handy help – just googled it and your post helped me out of this simple fix!
    Keep it up!
    :)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>