Support Board

Date/Time: Sun, 19 May 2024 21:54:18 +0000

Post From: Excel cross spreadsheet referencing

[2013-11-04 16:02:20] Link To Thread - Link To Post [Go To First Post]
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.