COMMAND in Microsoft Excel selectively pastes validation, formats, formulas, comments, etc.If you're dealing with cells that contain formulas, but you'd like to copy the values created by those formulas, FOLLOW the steps below:Highlight all of the cells containing the values you WANT to copy.Use the shortcut key Ctrl+C on a PC or Cmd+C on an Apple Mac to copy the text.Move to where you want to paste and right-click the cell. In the right-click menu, select Paste Special, which should OPEN a window which comprises of formulas, values, formats, validation, etc.Select Values and then click Ok.