How to Copy and Paste a Formula Without Changing Its Relative Cell References Many times you would like to copy a formula from one cell to another without shifting its relative cell references. This generally occurs when you would like to use a piece of it or it just has to be modified slightly for a new purpose. To accomplish this, first select the cell containing the formula and press the F2 key. This will put the formula into Edit mode. Next press the Shift+Home keys to select the entire formula then press Ctrl+c to copy it. After copying the formula hit the Esc key to cancel the formula edit. Last select the cell to copy to and press Ctrl+v.
Posted on: Sun, 30 Jun 2013 22:45:03 +0000
Trending Topics
Recently Viewed Topics
© 2015