03-13-2015, 07:53 PM

I'm not a spread sheet expert, just have learned things as needed. I have always found it irritating when copy and pasting a formula which has a fixed cell reference such as F8/C25 where F8 is value of a stock and C25 is a fixed value such as total asset value, that the spread sheet always adjusts for the new cell. Such that when copied and pasted in the next cell down, the formula above becomes F9/C26, then F10/C27, and so on. But in each case the denominator should have remained C25.

Yesterday my daughter shared this easy tip. Use the $ symbol to indicate a fixed reference, making the reference 'sticky' such that it does not change when copied into a new cell. The original formula becomes F8/$C$25. When copied to the next cell down, the formula becomes F9/$C$25, preserving the computation for weighting in this case. On a long line of cells, say my stock spreadsheet, going back and adjusting all of the C25 values has always been a pain. No more! Just tried this and it works like a charm.

Yesterday my daughter shared this easy tip. Use the $ symbol to indicate a fixed reference, making the reference 'sticky' such that it does not change when copied into a new cell. The original formula becomes F8/$C$25. When copied to the next cell down, the formula becomes F9/$C$25, preserving the computation for weighting in this case. On a long line of cells, say my stock spreadsheet, going back and adjusting all of the C25 values has always been a pain. No more! Just tried this and it works like a charm.

Alex