Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is meaning of $ in excel
Dear all
Plz help, what is meaning of $ in excel |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is meaning of $ in excel
Hi,
it makes a cell reference 'absolute' i.e. if you drag the formula the range doesn't change' there are 4 options =A1 - Row and column relative =$A1 - Row relative column absolute =A$1 - Row absolute column relative =$A$1 - Row and column absolute The easy way to change these id when you enter a range into a formula tap F4 and you will see the range change. tap a second time for the next option etc. Try the formula above in a sheet and drag them into new cells and you'll see practical examples. Mike "Sandeep Jangra" wrote: Dear all Plz help, what is meaning of $ in excel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What is meaning of $ in excel
The '$' character tells Excel not the adjust the column reference, the
row reference, or both, when you copy/paste or fill a range. Typically, if you enter =A1 and Fill down, Excel will change the formula to =A2, then =A3, then =A4 and so on down the filled range. The '$' character tells Excel not to adjust the reference. Thus, if you fill down the formula =A$1, all the cells will have that same formula since Excel doesn't adjust it. See http://www.cpearson.com/Excel/relative.aspx for more info about absolute and relative references. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com The San Diego Project Group, LLC (email is on the web site) USA Central Daylight Time (-5:00 GMT) On Sat, 11 Oct 2008 00:40:00 -0700, Sandeep Jangra wrote: Dear all Plz help, what is meaning of $ in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
meaning of E in y=3E-.05x^3 | Charts and Charting in Excel | |||
Excel 2002: Need to know the meaning of error meesage | Excel Discussion (Misc queries) | |||
In Excel, what is the meaning of " ^ " symbol in a formula? | Excel Discussion (Misc queries) | |||
meaning of ######### | Excel Discussion (Misc queries) | |||
meaning of this function | Excel Worksheet Functions |