| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what it mean by (=$AB$35 )
i would like to know the function of $ in Excel
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what it mean by (=$AB$35 )
"Kiran" wrote:
i would like to know the function of $ in Excel The $ sign in eg: $AB$35 makes that cell reference absolute, ie fixed, so that it won't change when you copy the formula containing: $AB$35 across or down. AB is the col ref 35 is the row ref There are 4 different states for any cell ref: AB35 - both col & row refs are relative $AB35 - col is fixed, row is relative AB$35 - col is relative, row is fixed $AB$35 - both col & row are fixed Depending on how you want the col/row refs to change as you copy a formula across/down, you would use one of the 4 states -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what it mean by (=$AB$35 )
Just to follow on Max's reply, to toggle between the different states, you
can simply press F4. Rgds, mwl "Max" wrote: "Kiran" wrote: i would like to know the function of $ in Excel The $ sign in eg: $AB$35 makes that cell reference absolute, ie fixed, so that it won't change when you copy the formula containing: $AB$35 across or down. AB is the col ref 35 is the row ref There are 4 different states for any cell ref: AB35 - both col & row refs are relative $AB35 - col is fixed, row is relative AB$35 - col is relative, row is fixed $AB$35 - both col & row are fixed Depending on how you want the col/row refs to change as you copy a formula across/down, you would use one of the 4 states -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what it mean by (=$AB$35 )
Cool tip! Thanks for sharing it!
-- Chuck M. "mwl" wrote: Just to follow on Max's reply, to toggle between the different states, you can simply press F4. Rgds, mwl "Max" wrote: "Kiran" wrote: i would like to know the function of $ in Excel The $ sign in eg: $AB$35 makes that cell reference absolute, ie fixed, so that it won't change when you copy the formula containing: $AB$35 across or down. AB is the col ref 35 is the row ref There are 4 different states for any cell ref: AB35 - both col & row refs are relative $AB35 - col is fixed, row is relative AB$35 - col is relative, row is fixed $AB$35 - both col & row are fixed Depending on how you want the col/row refs to change as you copy a formula across/down, you would use one of the 4 states -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
