We invite you to explore the materâial and information contained within this site and hope that you find it useful. Please contact the office with any questions, comments or ideas you may have about postdoctoral training at the Ohio State University College of Medicine. 908 Biomedical Research Tower (BRT) | (614) 685-9140 | postdoc.office@osumc.eduââââââââââââââââââââââââ.
Yeah. Just put the $ sign in front of your desired constant cell. Like $A6 if you wish to just change the number 6 serially and keep a constant, or $A$6 if you do not want anything from that reference to change at all. Example: Cell A5 contains my exchange rate.
These are called relative cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a $ before the column letter if you want that to always stay the same. Place a $ before a row number if you want that to always stay the same.