Chat with us, powered by LiveChat

Use Paste Special

How to Use Paste Special in Google Sheets

Use Paste Special

When you copy cell data, there are many ways it can be pasted. Some examples include:

  • Transpose Data: Copy columns to rows or vice versa.
  • Paste Values: Paste the results or values from a formula instead of copying and pasting the formulas themselves.
  • Paste Formulas: Copy formulas from a cell or cell range and apply it elsewhere.

Paste Formulas

  1. Select a cell that has a formula you want to copy.

    If this cell contains a formula and some formatting, both will be copied and pasted by default.

  2. Click Edit on the menu bar.
  3. Select Copy.
    Use Paste Special
  4. Select a cell to paste into.
  5. Click Edit on the menu bar.
  6. Select Paste special.

    The Paste Special options lets you paste aspects of the copied cell.

  7. Select Paste formula only.
    Use Paste Special

The formula is copied to the selected cell.

Paste Values

You can paste only the values as displayed in the cells, instead of the formulas that are used to calculate those values.

  1. With a cell copied, click a cell to paste into.
  2. Click Edit on the menu bar.
  3. Select Paste special.
    Use Paste Special
  4. Select Paste values only.
    Use Paste Special

Sheets pastes the values of the copied cell into the selected cell.

Transpose Data

You can also transpose data, or paste it so that its data is rotated from its rows and columns.

  1. Select a range of cells.
  2. Click Edit on the menu bar.
  3. Select Copy.
    Use Paste Special
  4. Select a cell to paste into.
  5. Click Edit on the menu bar.
  6. Select Paste special.
  7. Select Paste transposed.
    Use Paste Special

The cell range you copied earlier is pasted with the rows and columns flipped.

FREE Quick Reference

Click to Download