Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the difference !!!
hiiiii i want to know about Dollar Sign ($) used in Ms Excel formulas but i
have a bit confusion about the use of it first of all what is $ call in Excel is there any specific term used for it secondly what is the specific meaning of the following $ usage. i mean we can use it in different cell reference such as 1) A$1 2)$a1 3) $A$1 thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the difference !!!
The $ sign makes an address absolute so it won't change when you drag ot so:-
A$1 won't chnge when dragged down bit becomes B$1 when dragged right $a1 won't change when dragged right but becomes $A2 when dragged down $A$1 never changes when dragged. Mike "Naveed Pathan" wrote: hiiiii i want to know about Dollar Sign ($) used in Ms Excel formulas but i have a bit confusion about the use of it first of all what is $ call in Excel is there any specific term used for it secondly what is the specific meaning of the following $ usage. i mean we can use it in different cell reference such as 1) A$1 2)$a1 3) $A$1 thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the difference !!!
Hi,
Switch between relative, absolute, and mixed references 1. Select the cell that contains the formula. 2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , select the reference you want to change. 3. Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. For example, if you have a matrix A1: C3, then the following decription shows how the references are intrepreted. Reference (Description) Changes to $A$1 (absolute column and absolute row) $A$1 A$1 (relative column and absolute row) C$1 $A1 (absolute column and relative row) $A3 A1 (relative column and relative row) C3 Challa Prabhu "Naveed Pathan" wrote: hiiiii i want to know about Dollar Sign ($) used in Ms Excel formulas but i have a bit confusion about the use of it first of all what is $ call in Excel is there any specific term used for it secondly what is the specific meaning of the following $ usage. i mean we can use it in different cell reference such as 1) A$1 2)$a1 3) $A$1 thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the difference !!!
Thanks mike
"challa prabhu" wrote: Hi, Switch between relative, absolute, and mixed references 1. Select the cell that contains the formula. 2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , select the reference you want to change. 3. Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. For example, if you have a matrix A1: C3, then the following decription shows how the references are intrepreted. Reference (Description) Changes to $A$1 (absolute column and absolute row) $A$1 A$1 (relative column and absolute row) C$1 $A1 (absolute column and relative row) $A3 A1 (relative column and relative row) C3 Challa Prabhu "Naveed Pathan" wrote: hiiiii i want to know about Dollar Sign ($) used in Ms Excel formulas but i have a bit confusion about the use of it first of all what is $ call in Excel is there any specific term used for it secondly what is the specific meaning of the following $ usage. i mean we can use it in different cell reference such as 1) A$1 2)$a1 3) $A$1 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the difference between $D$13 and $D13 | Excel Worksheet Functions | |||
difference between the 2 | Excel Worksheet Functions | |||
Difference | Excel Worksheet Functions | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
Difference | Excel Worksheet Functions |