Support Board
Date/Time: Sun, 24 Nov 2024 15:01:53 +0000
Post From: Excel cross spreadsheet referencing
| [2013-11-04 16:02:20] |
| vegasfoster - Posts: 444 |
|
The $ sign locks the column and the row reference so they don't change as you copy. So if you leave $A and copy right, then it will still reference column A. If you delete the $ sign and copy right, then the A becomes B, C, D, etc. as you copy right. Same goes for the row reference and copying up or down. If you leave the $1, then as you copy down it will stay $1. If you want the 1 to become 2, 3, etc. then delete the $ sign. In your case, for sure you want to delete the $ sign before the row reference since you will be copying down. You may or may not want to delete the $ sign before the column reference, depending on what you are doing.
|