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.
The cell which you want to keep constant should be wrapped in $ sign. For example, your selling price is in cell E5 and if you want it to copy with E1 and drag it right. Then assuming, you want your formula at E2, then give like this. =E1*$E$5 and now if you drag/copy your cell E2 to your right side, then E5 will be constant. Vijay.