top of page

Using Paste Special in Google Sheets

Paste Special allows you to copy Conditional formatting, Data validation and more within Google Sheets.


How do I do this?


Step 1 - In Google Sheets right-click and select copy or use the shortcut CTRL+C (command+C Mac)


Screenshot shows a drop down menu in Google Sheets














Step 2 - Select the location where you want to paste some of the contents


Step 3 - Right-click, select ‘Paste Special’ and select what you want to paste


Screenshot shows right click paste special options in Google Sheets









There are the following options you can choose from:


Values only

Format only

Condition formatting only

Data validation only

Transpose (switch rows to columns or columns to rows)

Column width only

All except borders


Learn more with our Google Sheets course


Comments


Recent Posts