I'm assuming you mean in a Cell formula. the $ is an "anchor".
Let's say you have a column of numbers in column "A" rows 2-10. In row 1 you have different numbers in column "B" through "E" so it looks like: X 1 2 3 1 2 3 Now, in the rest of the rows and columns you want to multiply the value in column "A" with the value in row 1. so in cell B2 you use: =A2*B1 now you copy this cell to the rest of the cells and it DOESN'T WORK! the Cell in C2 is: =B2*C1 when you WANTED =A2*C1 and in cell C3 it's: =B3*C2 when you wanted: =A3*C1 so... you need a way to tell excel to NOT change Column "A" in the first cell reference, and not change the ROW (1) in the second Cell reference. To do that, you tell excel to "anchor" the "A" column by using $A and "anchor" the row by using $1 the formula in B2 is then: =$A2*B$1 Now, when you copy the cell formulas, the A stays the same, but the row changes.. This is actually referred to as using ABSOLUTE references and Relative references. the $A is the ABSOLUTE column A. so when you copy it, it remains "A" but for "B", well, the current cell is column "B", so when you copy it to column C, the formula changes to "C".. does that help? Paul ________________________________ From: D M Sukumar <vijayajith...@gmail.com> To: excel-macros@googlegroups.com Sent: Sat, January 29, 2011 12:33:37 PM Subject: RE: $$Excel-Macros$$ Please help Hai groups, Can you tell me what is the use of $ sign excel;;;; And can you give some examples please;;; Thank you From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
