Google Sheets lets you copy and paste text and images between
all of your documents, spreadsheets, and presentations — even if
you're going from one type to another. For most uses, you can
copy and paste with keyboard shortcuts (Ctrl+C and Ctrl+V on a
PC, ⌘ + C and ⌘ + V on a Mac). When you copy data, the border of
the cell or range of cells will turn solid orange to help you
remember where you copied the data from. When you cut data from
a cell or a range of cells, you'll see an orange dotted line
around the cell(s). Copying and pasting in Google Sheets copies
all properties of a cell into the cell you're pasting into,
including text, formatting, and data validation. The paste
special option gives you more control about what properties
you're copying and pasting into a range of cells. To use one of
the paste special options, click the Edit menu, navigate to
Paste Special..., and select from the following options: - Paste
values only: Pastes only the text contained in the original
range of cells. - Paste form