3. Excel Tips - Easily paste special values - Hidden Menu
A neat trick that most people don't know (even some professed experts) is a quick way of pasting values.
Type anything in cell A1
Right click on the right hand side of selection, and drag slightly to the right
A Hidden menu will appear:
Training Video on easily Pasting Values: