How to Use Paste Special in Google Sheets
When you copy cell data, there are many ways it can be pasted. Some examples include:
If this cell contains a formula and some formatting, both will be copied and pasted by default.
The Paste Special options lets you paste aspects of the copied cell.
The formula is copied to the selected cell.
You can paste only the values as displayed in the cells, instead of the formulas that are used to calculate those values.
Sheets pastes the values of the copied cell into the selected cell.
You can also transpose data, or paste it so that its data is rotated from its rows and columns.
The cell range you copied earlier is pasted with the rows and columns flipped.