Forum Discussion
Solved
Need key that is used to refer to a particular cell when copying formula in Excel spreadsheet
I need to compute costs in forehgn money using exchange rate in table. How do I avoid having to retype exchange rate for each cell with a formula? (what key do I use?)
- Wonderful
That is what I remember. I will be 80 in a couple of months and haven't used that feature in years, I was kicking myself for forgetting the trick. I normally do not resort to visiting a chat rooms because I might get lost there and have no idea what to expect as a result. Your help has made my day! My wife and have a 502(c)3 "Living Water for Kenya" (livingwaterforKenya.org) which requires our attention via internet daily. I work alot with spreadsheets and this will help. We have been to Kenya 19 times since 2005. Thanks again David Hansen Email address removed.
dw-hansen Take a look at the range name function. You can name a cell (e.g. the USD - GBP exchange rate) as USGBP and then refer to USGBP in your formulas. See more here https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
- Although that wasn't exactly what I recall one uses to hold constant a part of a formula as the formula moves arround, It did the job well.