{"id":1618,"date":"2022-05-13T16:20:37","date_gmt":"2022-05-13T10:50:37","guid":{"rendered":"https:\/\/sheetstips.com\/?p=1618"},"modified":"2022-05-23T10:23:24","modified_gmt":"2022-05-23T04:53:24","slug":"how-to-use-the-paste-special-options-in-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/how-to-use-the-paste-special-options-in-google-sheets\/","title":{"rendered":"How to Use Paste Special Options in Google Spreadsheet? Google Sheets Paste Special Explained"},"content":{"rendered":"<p>Google Sheets is a web-based spreadsheet application, like Microsoft Excel, which allows you to store and organize various types of information. While Google Sheets does not have all of the advanced features of Excel, it is simple to create and edit spreadsheets ranging from simple to complex. Like Excel, Google Sheets also comes with Paste Special Options, where we have a range of pasting options. If you are new to Google Spreadsheet and want to know the list of Paste Special Options, then this page is for you. On this page let us learn everything about Google Sheets Paste Option using the <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheets Tips<\/a><\/strong> provided on this page. Read further to find more.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#List-of-Paste-Special-Options-Available-in-Google-Sheets\">List of Paste Special Options Available in Google Sheets<\/a><\/li>\n<li><a href=\"#How-To-Enable-Paste-Special-Options-in-Google-Sheets?\">How To Enable Paste Special Options in Google Sheets?<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Values-Only\">Google Sheets Paste Values Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Format-Only\">Google Sheets Paste Format Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-All-Expect-Borders\">Google Sheets Paste All Expect Borders<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Column-Widths-Only\">Google Sheets Paste Column Widths Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Formula-Only\">Google Sheets Paste Formula Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Data-Validation-Only\">Google Sheets Paste Data Validation Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Conditional-Formatting-Only\">Google Sheets Paste Conditional Formatting Only<\/a><\/li>\n<li><a href=\"#Google-Sheets-Paste-Transposed\">Google Sheets Paste Transposed<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"List-of-Paste-Special-Options-Available-in-Google-Sheets\">List of Paste Special Options Available in Google Sheets<\/h2>\n<p>Google Sheets provides a number of Paste Special options. In addition to values, you can paste formulas, conditional formatting, and other things with many of these.<\/p>\n<ol>\n<li>Paste Values Only<\/li>\n<li>Paste Format Only<\/li>\n<li>Paste All Except Borders<\/li>\n<li>Paste Column Widths Only<\/li>\n<li>Paste Formula Only<\/li>\n<li>Paste Data Validation Only<\/li>\n<li>Paste Conditional Formatting Only<\/li>\n<li>Paste Transposed<\/li>\n<\/ol>\n<h3 id=\"How-To-Enable-Paste-Special-Options-in-Google-Sheets?\">How To Enable Paste Special Options in Google Sheets?<\/h3>\n<p>In order to enable the Paste Special option in Google Spreadsheet, we need to first create a dataset. Post creating your dataset, follow the steps as outlined below to enable the Paste Special Options in Sheets.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet and move to the dataset.<\/li>\n<li><strong>Step 2:<\/strong> Now copy the dataset by selecting the required cell range. To copy, select the dataset, right-click anywhere on the screen, and choose &#8220;<strong>Copy<\/strong>&#8220;. Alternatively, you can also use the keyboard shortcut &#8220;<strong>Ctrl+C<\/strong>&#8221; to copy the dataset.<\/li>\n<li><strong>Step 3:<\/strong> Now head to the cell where you want to paste the data and right click on the cell.<\/li>\n<li><strong>Step 4:<\/strong> Soon after Right-Clicking the cell, you will see &#8220;<strong>Paste Special<\/strong>&#8221; options.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1624 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets.png\" alt=\"how-to-use-the-paste-special-options-in-google-sheets\" width=\"1300\" height=\"516\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets.png 1300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets-300x119.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets-1024x406.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets-768x305.png 768w\" sizes=\"(max-width: 1300px) 100vw, 1300px\" \/><\/p>\n<p>That&#8217;s it, your Paste Special Options has been enabled.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/convert-formula-to-value-google-sheets\/\">How to Convert Formula to Value in Google Sheets?<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-a-google-sheets-spreadsheet-into-google-docs\/\">How to Insert a Google Sheets Into Google Docs (Merge Google Sheets with Docs)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/drop-down-list-in-google-sheets\/\">How to Create a Drop Down List in Google Sheets: Add\/Remove\/Customize Drop Down Menu<\/a><\/li>\n<\/ul>\n<h3 id=\"Google-Sheets-Paste-Values-Only\">Google Sheets Paste Values Only<\/h3>\n<p>Paste Values Only is similar to the plain text paste function in Microsoft Excel. This action only pastes the text without any formatting. If the data you are\u00a0copying contains a formula, Paste Values Only will only paste the formula&#8217;s result.<\/p>\n<p>Here we have used a formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1623 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets1.png\" alt=\"how-to-use-the-paste-special-options-in-google-sheets\" width=\"556\" height=\"468\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets1.png 556w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets1-300x253.png 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/p>\n<p>Now when we are pasting the data using Paste Values, it pastes as shown in the image given below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1622 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets2.png\" alt=\"how-to-use-the-paste-special-options-in-google-sheets\" width=\"1146\" height=\"468\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets2.png 1146w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets2-300x123.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets2-1024x418.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets2-768x314.png 768w\" sizes=\"(max-width: 1146px) 100vw, 1146px\" \/><\/p>\n<h3 id=\"Google-Sheets-Paste-Format-Only\">Google Sheets Paste Format Only<\/h3>\n<p>If you only want to paste the formatting and not the data, Paste Format Only is the action to use. This is a better option than the Paint Format tool because it does not change any data and only pastes formatting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1621 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets3.png\" alt=\"how-to-use-the-paste-special-options-in-google-sheets\" width=\"1167\" height=\"466\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets3.png 1167w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets3-300x120.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets3-1024x409.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets3-768x307.png 768w\" sizes=\"(max-width: 1167px) 100vw, 1167px\" \/><\/p>\n<h3 id=\"Google-Sheets-Paste-All-Expect-Borders\">Google Sheets Paste All Expect Borders<\/h3>\n<p>Data with borders, formulas and another formatting may exist in the copied data. Paste All Except Borders performs exactly as it sounds. Except for cell borders, it pastes everything you copy, including data and formatting. When moving data around, this option allows you to avoid reformatting your borders.<\/p>\n<h3 id=\"Google-Sheets-Paste-Column-Widths-Only\">Google Sheets Paste Column Widths Only<\/h3>\n<p>When you take the time to precisely size columns in Google Sheets, you may want to carry those sizes throughout your sheet. Only the column widths are pasted to your selected cells when you use Paste Columns Widths Only.<\/p>\n<h3 id=\"Google-Sheets-Paste-Formula-Only\">Google Sheets Paste Formula Only<\/h3>\n<p>The opposite of Paste Values is\u00a0 Paste Formula which only actually pastes the formula where you only see the result of a copied formula. When adding totals to rows or columns, this paste special option comes in handy. Simply copy and paste the formula into the other cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1620 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets4.png\" alt=\"how-to-use-the-paste-special-options-in-google-sheets\" width=\"1120\" height=\"479\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets4.png 1120w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets4-300x128.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets4-1024x438.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/paste-special-options-in-Google-Sheets4-768x328.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/><\/p>\n<h3 id=\"Google-Sheets-Paste-Data-Validation-Only\">Google Sheets Paste Data Validation Only<\/h3>\n<p>In Google Sheets, data validation can prevent incorrect data from being entered into your sheet. So, if you create a data validation rule, you can copy and paste that rule to other cells in your sheet using Paste Data Validation Only. Except for the data validation, nothing else will be pasted.<\/p>\n<h3 id=\"Google-Sheets-Paste-Conditional-Formatting-Only\">Google Sheets Paste Conditional Formatting Only<\/h3>\n<p>You can use conditional formatting in Google Sheets to highlight blanks or errors and apply colour scales based on values. Copy and paste a conditional formatting rule that you want to apply to other areas of your sheet with Paste Conditional Formatting Only if you want to apply it to other areas of your sheet. The only thing that will be pasted in the conditional formatting.<\/p>\n<h3 id=\"Google-Sheets-Paste-Transposed\">Google Sheets Paste Transposed<\/h3>\n<p>Paste Transposed is the last but not the least option available in the Google Sheets Paste Special options. The paste Transposed option is one of the most useful options which is widely used in Google Spreadsheets. Paste Transposed is the final and, in many ways, most useful of the paste special options. You can use this feature to copy cells from a column and paste them into a row, or vice versa. Through essentially, it enables you to <strong><a href=\"https:\/\/sheetstips.com\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">convert a column to a row<\/a><\/strong> or a row to a column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1603 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets1.png\" alt=\"convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets\" width=\"512\" height=\"329\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets1.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/11\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets1-300x193.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets is a web-based spreadsheet application, like Microsoft Excel, which allows you to store and organize various types of information. While Google Sheets does not have all of the advanced features of Excel, it is simple to create and edit spreadsheets ranging from simple to complex. Like Excel, Google Sheets also comes with Paste &#8230; <a title=\"How to Use Paste Special Options in Google Spreadsheet? Google Sheets Paste Special Explained\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/how-to-use-the-paste-special-options-in-google-sheets\/\" aria-label=\"More on How to Use Paste Special Options in Google Spreadsheet? Google Sheets Paste Special Explained\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":284,"url":"https:\/\/sheetstips.com\/convert-pdf-to-google-sheets\/","url_meta":{"origin":1618,"position":0},"title":"How to Convert PDF to Google Sheets: Free Online Conversion","author":"Varsha","date":"May 19, 2022","format":false,"excerpt":"Converting PDF to Google Excel Sheets is the process of converting the PDF file into the G-Sheet. Usually, you might receive the scanned copy of the dataset in a PDF file which needs to be operated in Google Sheet. Unfortunately, G-Suite doesn't provide us with the option where we can\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"How to Convert PDF to Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Convert-PDF-to-Google-Sheets-9.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":431,"url":"https:\/\/sheetstips.com\/open-csv-file-google-sheets\/","url_meta":{"origin":1618,"position":1},"title":"How to Import and Open CSV File in Google Sheets: 3 Shortcut Methods","author":"Varsha","date":"May 19, 2022","format":false,"excerpt":"CSV to Google Sheets: CSV stands for comma-separated values, and it's a file format that contains a list of data separated by commas. These files allow data to be transferred rapidly and effortlessly from one source to another. While a CSV file can be opened using a variety of apps,\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"csv-to-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Example-of-converting-a-CSV-to-a-Google-spreadsheet-part-3-clicking-File-Upload.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1590,"url":"https:\/\/sheetstips.com\/open-spreadsheets-in-completely-separate-windows\/","url_meta":{"origin":1618,"position":2},"title":"How To Open Google Spreadsheet in New Window? (View Two Tabs at Once)","author":"Varsha","date":"May 14, 2022","format":false,"excerpt":"While working with a huge dataset, users might often tend to view and edit data from multiple sheets in the same spreadsheet. However, this option isn\u2019t available in Google Sheets like we have in Excel Sheets. Also if you Freeze the Sheet and start entering the data from tabs of\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"How To Open Google Spreadsheet in New Window","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/How-To-Open-Google-Spreadsheet-in-New-Window-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3444,"url":"https:\/\/sheetstips.com\/clear-formatting-in-google-sheets\/","url_meta":{"origin":1618,"position":3},"title":"How To Clear Formatting in Google Sheets ? &#8211; Remove Formatting","author":"Varsha","date":"June 17, 2022","format":false,"excerpt":"Google Sheets is one of the best spreadsheet programs that help users work with large datasets. Also, one of the main reasons for using Google Sheets is that it allows its users to format the data and make it appear in a more presentable way. There are plenty of formatting\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"clear formatting in Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/clear-formatting-in-Google-Sheets-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1601,"url":"https:\/\/sheetstips.com\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets\/","url_meta":{"origin":1618,"position":4},"title":"How to Convert Rows to Columns or Backwards in Google Sheets?","author":"Varsha","date":"May 14, 2022","format":false,"excerpt":"When a user is dealing with a large number of Spreadsheets, it is quite common for one to convert rows to columns or backward. Google Sheets allows users to convert rows to columns and column to rows using Google Transpose Function. As the name suggests, the Transpose Function in Google\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":997,"url":"https:\/\/sheetstips.com\/convert-formula-to-value-google-sheets\/","url_meta":{"origin":1618,"position":5},"title":"How to Convert Formula to Value in Google Sheets?","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"When working with Google Sheets, we use n number of formulas and functions. However, when we are copying formula applied cells from one cell to another cell, the Google Sheets will show up an error. This error will be shown due to the difference in cell reference numbers that we\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-formula-to-value-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/convert-formula-to-value-google-sheets4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1618"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=1618"}],"version-history":[{"count":5,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1618\/revisions"}],"predecessor-version":[{"id":2559,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1618\/revisions\/2559"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=1618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=1618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}