MS Excel

Ever have to create a column of formulas that are very similar? When you completed a copy/paste, were you upset to find that the cell references were changed during the paste? The ability to force Excel to perform an exact copy of the contents from the cell above your current location might just come in handy: To get an exact copy (no cell reference changes at all) of the cell directly above, simply use Ctrl + '. Select a cell, hit Ctrl + ' and poof, the contents of the cell above are duplicated immediately!