Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello out there,
I have just recently learned Absolute Statements and am having some trouble grasping the following. I understand that you can lock the row and the column by using the dollar sign - hitting short cut key F4. (Ex: =B24*$B$27). If I continue to hit F4 I can then just lock the row or the column. I would like to know what is reason for locking just a row or a column? As well if I lock a row does that mean that any other information that is in that row is locked as well? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Pivot tables Excel 2003 absolute references | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) |