How to Enable Paste Option in Excel (3 Suitable Ways)

Error in Paste or Paste Special can happen while pasting in Excel. Excel is sometimes unable to show paste options due to settings error or may be corrupted excel files is the main reason that makes the paste error. In this article, we will show how to enable the paste option in Excel.


3 Simple Ways to Enable Paste Option in Excel

To demonstrate the method or possible do’s, we will use the data of Country in column B and National Sport in column C like the below image.

the data of Country in column B and National Sport in column C


1. Enable Paste Option from Excel Advanced Options

Often, we make a change after pasting data in Excel with the Paste Options appearing at the downside of the pasted data. But sometimes the data may not appear in Excel for some settings problems. In this method, we will try to solve the problem.

📌 Steps:

  • We cannot see any Paste Options in the following image. But we can bring back the option by changing some settings which we will demonstrate in the later parts of this method.

cannot see any Paste Options in the following image

  • To take back the Paste Options, we will go to File >> Options.

Enable Paste Option from Excel Advanced Options

  • In the crucial part of this method, we will do the followings: Excel Options>> Advance >> Mark the box beside ‘Show Paste Options Button When Content Is Pasted’ >>OK.

Enable Paste Option from Excel Advanced Options

  • After completing the process, we can now see the Paste Options in Excel like the following image.

Enable Paste Option from Excel Advanced Options

Read More: How to Paste From Clipboard to Excel Using VBA


Similar Readings


2. Unprotect a Protected Worksheet

The protected sheet in Excel will disable Paste Option because the sheet is password protected. In the following steps, we will demonstrate how to deal with the case.

📌 Steps:

  • In the following image, we have tried to demonstrate copy and paste of cells in B4:C14 and paste it in cell E4.

copy and paste of cells in B4:C14

  • Then Microsoft Excel will show a message, “The cell or chart you’re trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password.” That actually means to enable copy and paste in Excel we first have to unprotect the sheet.

That actually means to enable copy and paste in Excel we first have to unprotect the sheet

Unprotect the Sheet

  • Now a tab named Unprotect Sheet will appear on the screen. In the box of Password, we will enter the code to unprotect the sheet.

a tab named Unprotect Sheet will appear

  • At this moment we can enable Copy and paste option in Excel.

we can enable Copy and paste option

Read More: How to Disable Copy and Paste in Excel without Macros (With 2 Criteria)


3. Enable Select & Paste Option for Visible Cell Only

If we require to copy and paste visible cells only, we can’t do that as usual copy and pasting. To learn the method Enable Select & Paste for Visible Cell Only follow the below steps.

📌 Steps:

  • Suppose we have a hidden column in C. Moreover, we have to copy the visible cells only.
  • Now if we copy the cells and paste them into F4, we can see that the hidden column C has also appeared in the pasted dataset.
  • Now we will follow the steps to avoid the hidden column being copied.

the hidden column C has also appeared in the pasted dataset

  • Go to the Home ribbon >> Click on Find & Select under Editing group >> Choose Go To Special…
  • Or Press Ctrl + G >> Click on Special… from the Go To window.

Choose Go To Special…

  • Put the radio button on Visible cells only under the Select options. Click on the OK button

Put the radio button on Visible cells only under the Select

  • Now we will do the process of copying and pasting cells and see the result that has shown the copy and paste of visible cells only.

copy and paste of visible cells only

Read More: How to Copy and Paste Multiple Cells in Excel (8 Quick Methods)


Conclusion

Follow these steps and stages on how to enable the paste option in excel. You are welcome to download and use the workbook for your practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, i am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo