I have had this piece of code in my Personal.xls file for years. It is very handy when you are sending files to colleagues and want to reduce the file size or complexity.

Sub PasteValue()
'
' Keyboard Shortcut: Ctrl+Shift+V
'
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub

Select the section you want to turn to values and press Ctrl+Shift+V

Many users do not know that Excel has a spell check command. Excel’s Spelling command can eliminate some misspelled words. The file should always be reviewed for words that are spelled correctly but are not what the user intends. Unlike Microsoft Word, the spell check cannot be turned always on and does not have a grammar check.

When presenting spreadsheets to others in business or personal situations, it is important to prepare accurate and professional documents. Errors and misspelling reflect poorly on the presenter.

The keyboard shortcuts for copy and paste are:

• Copy Ctrl+C
• Cut Ctrl+X
• Paste Ctrl+V

Ctrl+V gives you to the option of repeating the operation, i.e. the clipboard is not emptied. If you paste using Enter you are not able to repeat the operation. This is like pressing Ctrl+V and then Esc