Paste Special Not Working On Excel Code Or Text

Every time I copy data with formatting and formulas and attempt to Paste Special it only gives me the option to Paste as Unicode or Text.

I should have a whole list of options, such as Paste Formulas, Paste with formatting and etc., but they are not appearing.

I have reinstalled office and started Excel in safe mode and it still does the same thing every time.

Especially when copying text already within Excel to another cell within Excel.

Try these tests. 1.

Type some numbers in excel, hilight them, then try right-clicking in another cell and see what options show up.

Copy some text from a web page, right-click in an Excel cell and see what options show up.

You may not see a host of options but you should see HTML show up.

Bring up google.com in your web browser.

Right click on the logo and select Copy Image (I am using the Chrome browser).

If you click Paste Special, you should see Bitmap as an option.

If none of the above shows you any love, check to see what your default excel spreadsheet format is when you open it.

If your default is opening as a.csv file it may not give you special options.

Try saving the spreadsheet as a.xlsx file, re-open it, then try pasting by right-clicking and see what happens.

Like copying and pasting an image or web link (for both cases, the Paste Special window will not appear).

I am trying to copy formulas and past them and that doesnt work.

Formulas should give you the option to either paste with formulas or just the values.

The same thing goes if I place a border around the cells, I should get the option to paste with formatting or just the data.

I can do all this fine on another machine using the same data.

To see if Paste Special is enabled:Go to: File Options Advanced.Under Cut, copy and paste, ensure Show Paste Options button when content is pasted is checked.

Ensure that all instances of the web browsers that you use are Closed and try to use Paste Special again.

Paste Special will not function if your web browser is causing the conflict.

Windows Internet Explorer (8-9) do not conflict with the Excel 2010 Paste Special option.

Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option.

Paste Special Not Working On Excel For Mac