Lost Paste Special function in Excel - How to find it again?

Losing the Paste Special function in Excel is a mistake that makes you 'sweat'. Learn how to fix this situation in detail in TipsMake's article!

It seems that when you need to copy and paste in Excel, the keyboard shortcuts Ctrl + C and Ctrl + V are very popular. However, to have more choices, the Paste Special function in Excel is the optimal choice for you. But like many other features, sometimes Paste Special does not work properly, causing obstacles for users in their work. Join TipsMake to learn how to fix the problem of losing the Paste Special function in Excel in the next section.

Lost Paste Special function in Excel - How to find it again? Picture 1

Detailed instructions on how to fix the error of losing the Paste Special function in Excel

Paste Special error in Excel may be due to the user not applying the Paste Special trick correctly. For example, you pressed the wrong Paste Special key combination. Or it's also possible that the version of Excel you're using is corrupted so it doesn't work properly. The detailed fix is ​​as follows:

Instructions for using Paste Special in Excel

Paste Special in Excel are paste options for you after copying data. In this table there are many options suitable for your work. Here's how.

1. Step 1: Find the content/cell with data to copy > Highlight > Right-click and select Copy or press Ctrl + C.
2. Step 2 : Move to the cell where you want to paste the data. Right-click this area > Select Paste Special or use the Paste Special shortcut in Excel which is Ctrl + Alt + V . At this point, the Paste Special panel will display and you just need to select the paste option you need. In there:

   1. For the Paste area

   2. All > This is the option to paste all content and formats.
   3. Formulas > This option only pastes formulas.
   4. Values ​​> This is the option to paste values ​​only.
   5. Formats > How to paste in Excel preserves the formatting because it only pastes the formatting.
   6. Comments > This option only pastes comments and assigned comments in the cell.
   7. Validation > This option will paste the data import rules.
   8. All using Source theme > This option will help you paste all Theme formats in the spreadsheet.
   9. All except borders > This is the option to paste everything (except the border format).
   10. Column widths > This option helps paste the widths of columns.
   11. Formulas and number formats > This option will help you paste only formulas and all number formats.
   12. Values ​​and number formats > This is the option to paste only values ​​and all number formats.

   13. For the Operation area – Perform calculations

   14. None > This is an option where no calculation is performed when pasting data.
   15. Add > This option results in the data in the target cell plus the copied data.
   16. Subtract, Multiply, Divide are similar to the Add option but subtract, multiply and divide.

   17. Other areas

   18. Skip blanks > If you tick, the value of the cell or block of cells will not be replaced when the copied cell is blank.
   19. Transpose > This option converts the position of copied columns to rows and rows to columns.

Lost Paste Special function in Excel - How to find it again? Picture 2

1. Step 3 : After checking, click OK to apply.

Instructions on how to fix the error of losing the Paste Special function in Excel

1. Some people encounter a very strange situation where Paste in Excel only shows the text format. For this situation, try checking to see if you have set the cell format (need to paste data) to text format before? Because this is likely the cause of the problem.
2. There are also users who encounter the error that the Paste Special panel only displays some options such as text and unicode text but does not have a full dialog box. The cause is said to be due to the Skype application . If installed, open Google Chrome browser, on the right corner near the control option (wrench image) there is a skype add-on icon, users should try uninstalling this add-on and check the problem .
3. In the remaining cases, there is a high possibility that the Excel version you are using is corrupted. Or you installed the crack version so it doesn't have full functionality. Please delete and reinstall another version of Excel from Microsoft to see if it works!

Above is how to fix the error of Losing Paste Special function in Excel. Hopefully my suggestions will help you fix the error successfully!

Isabella Humphrey

Update 09 December 2023