Excel: How to Drag Without Changing Numbers
Thank God for copy/pasting, where would we be without it? Some of us like to Ctrl+C/Ctrl+V everything, including Excel formulas. There's just a little problem though – cell referencing changes when you copy cells with formulas, which can set things completely out of whack. This is how to copy cell values and formulas without changing