Relative referencing which is the default referencing Absolute referencing Mixed Referencing
Important points
4 type of referencing can be cycle through f4 key - when we are in edit mode of cell - (use f2 to enter into edit mode) - A1 , $a$1 , A$1, $A1
Shortcut Ctrl + ~ (tilde which is just above 1 in windows)
pl download file
- Read more...
- 1 comment
- 3,649 views