How to Use Paste Special Shortcut in Google Sheets (2 Examples)

Copy-paste is a common operation when working with Google Sheets. The Paste special option enables us different ways to paste the copied data. From these options, you can select whether you want to copy only the values, copy only the format, or copy only in another way. It is simple and efficient to use shortcuts when using the Paste special options. In this article, we will discuss how to use Paste special shortcut in Google Sheets.

overview of the article to paste special shortcut in Google Sheets

The above screenshot is an overview of the article representing How to Use Paste Special Shortcut in Google in Sheets. You will learn the step-by-step procedure to use the paste special shortcut in Google Sheets.


2 Quick Examples of Paste Special Shortcuts in Google Sheets

The Paste special option in Google Sheets allows users to paste copied data in a variety of ways, including Paste values only, Paste format only, Paste formula only, Paste in transposed form, etc. There are shortcuts for these options to paste special.

Suppose you have a dataset of different formats of values and their examples. Now you need to use a shortcut to paste the values in Google Sheets.

Dataset to use paste special shortcut


1. Shortcut to Paste Values Only

This option of Paste special in Google Sheets enables us to paste the values only. Any kind of data or cell formatting or formula will not paste while using this option. Follow the below steps to paste the value using a shortcut.

๐Ÿ“Œ Steps:

  • First of all, select the range C5:C10 and press CTRL + C to copy the data.

Copying the Example column to paste values only

  • Then, select cell E5 and use the shortcut CTRL + SHIFT + V to paste the copied data.

Pasting the copied data using the shortcut for pasting values only

  • Lastly, the output will look like the following image. Here, we can see that no text or cell formatting has been pasted. Only the copied values are pasted.

The output of paste values only shortcut

Read More: [Fixed!] Google Sheets Paste Special Not Working (2 Solutions)


2. Shortcut to Paste Format Only

In Google Sheets, we can only paste format using the Paste special option. When using this option, any type of data or values will not paste. Only the formatting of cells and data will paste. Here are the steps to paste the format using a shortcut.

๐Ÿ“Œ Steps:

  • In the beginning, select the range C5:C10 and press the shortcut CTRL + C to copy the data.

Copying the example column to paste format

  • Now, select cell E5 and use the shortcut CTRL + ALT + V to paste the copied data.

Selecting a cell and pasting the format using a shortcut

  • Finally, the output will look like the following image. Here, we can see that no text or values have been pasted. Only the formatting is pasted.

The output of paste special shortcut


How to Use All Paste Special Options in Google Sheets

All other Paste special options can be used based on your requirements. When you right-click on a cell, you can find the Paste special option in the context menu. You can also find the Paste special option in the top menu bar by selecting options Edit >> Paste special.

finding paste special options from the top menu bar option Edit

Now, follow the steps below to learn about the options.

๐Ÿ“Œ Steps:

  • Firstly, to paste the formula only, copy the range C5:C10 just like before.
  • Then, select cell E5 and select Paste special >> Formula only options from right-click menu.

Selecting options to paste formula only

  • The output will look like the following image.

Output of selecting option formula only

  • Secondly, to paste the values in transposed form, copy the range C5:C10.
  • Now select Paste special >> Transposed options from right-click menu of cell E5.

Selecting option to paste as transformed form

  • The following output will be found.

Output of selecting option Transposed

  • Similarly, to paste the values without the cell border, first, copy the range C5:C10.
  • After that, right-click on cell E5 and select options Paste special >> All except borders.

Selecting options to paste data except border

  • The final output will look like the following image.

Output of selecting option All except border


Things to Remember

  • Press the shortcut key to paste the data with caution.
  • To paste the data, choose the appropriate cell.

Conclusion

Hopefully, you can now use shortcuts to paste special in Google Sheets after going through the article. If you have any queries or suggestions please comment below. Visit the OfficeWheel website for more Google Sheets-related helpful articles.

Jawadul Islam Chowdhury

Jawadul Islam Chowdhury

Hello! This is Jawad. I create Google Spreadsheets-related content for OfficeWheel. I enjoy doing research and solving Google Spreadsheet-related problems. I love to learn new things and teach them to others.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo