How to copy and paste text and formulas in an Excel spreadsheet

Updated: 06/30/2019 by Computer Hope
Microsoft Excel.

Below are the steps on how to copy and paste text as well as formulas in a Microsoft Excel spreadsheet.

How to copy and paste text in Excel

Microsoft Excel works like most other programs for copying and pasting plain text. To copy and paste any cells containing only text in an Excel spreadsheet, follow the steps below.

  1. Highlight all of the cells you want to copy.
  2. Use the shortcut key Ctrl+C on a PC or Cmd+C on an Apple Mac to copy the text.
  3. Move to the location you want to paste the text and use the shortcut key Ctrl+V on a PC or Cmd+V on an Apple Mac to paste the text.

How to copy and paste only the values in Excel

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.

  1. Highlight all of the cell containing the values you want to copy.
  2. Use the shortcut key Ctrl+C on a PC or Cmd+C on an Apple Mac to copy the text.
  3. Move to the location you want to paste and right-click on the cell and in the right-click menu select Paste Special, which should open a window like the example shown below.

Excel Paste Special window with values selected

  1. Select Values and then click Ok.

How to copy and paste formulas in Excel

Note

Most formulas are created using a relative cell reference and when these formulas are copied the references will be changed automatically. If you do not want the cell references to be changed, the formula must be an absolute cell reference.

  1. Highlight all of the cell containing the formula you want to copy.
  2. Use the shortcut key Ctrl+C on a PC or Cmd+C on an Apple Mac to copy the text.
  3. Move to the location you want to paste and right-click on the cell and in the right-click menu select Paste Special, which should open a window like the example shown below.

Excel Paste Special window

  1. Select Formulas and then click Ok.