By default, the original formatting of the content will stay the same.

Paste the content in the same spreadsheet.

In a spreadsheet, copy the content you want to paste.

You can format the content after you paste it. For example, if you copy a column of cells and use paste transpose, it will paste them into a row, and vice versa.

Paste transposed: Pastes a rotated version of the copied cells.

Paste conditional formatting only: Only applies conditional formatting rules to a range of cells.

Paste data validation only: Pastes a data validation rule over a range of cells without changing existing formatting, formulas, or text.

Paste formula only: Pastes the formulas contained in a copied range of cells, not the resulting calculations of the formulas.

Paste column widths only: Resizes the selected columns to match the original.

Paste all except borders: Pastes everything except cell borders.

Paste format only: This option is identical to using the paint format tool - it only copies cell formatting, and won't change existing text or formulas.

Paste values only: Pastes only the text from the original range of cells.Copy the data you want to paste and put your cursor in the cell you want to paste into.On your computer, open a spreadsheet in Google Sheets.You can't copy cells from one spreadsheet and use paste special in a spreadsheet open in another tab.

Paste special works only within a single spreadsheet. You can use paste special to decide which formatting gets copied when copying cells.

Mac os paste to desktop