Select the text or data that you want to copy.
Click the Home tab.
Click the Copy button.
Click the new location.
Click the Paste button, and then click Paste Special.
Choose the option.