Excel+Formulas+Copy+Exactly

Excel Formulas Copy Exactly Did you ever wish to copy a formulae exactly and not have the cell references changed during paste ?

Well you can and here is how:- To get an exact copy (no cell reference changes at all) of the cell directly above, simply use Ctrl + '. Select a cell, ( Highlight it ) hold down Ctrl press ‘ ( That is the key which has the @ sign above i),, the contents of the cell above are duplicated immediately Always remember not every version of windows.  