Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Google Spreadsheet paste doesn't work

more options

I have recently given up my Microsoft office account, and when needing to share a spreadsheet I'm now using Google Spreadsheet though the web browser, but when I try and paste into a google spreadsheet using the right click mouse button menu I get a popup https://cdn.discordapp.com/attachments/357648397920108548/621073069493977088/unknown.png that says copying and pasting in google docs, these actions are unavailable using the edit menus, but you can still use ctrl+c for copy ctrl+x for cut ctrl+v for paste, but when i use the control+v for paste i get and empty cell with a little clipboard menu https://cdn.discordapp.com/attachments/357648397920108548/621073154416050189/unknown.png that I then have to click on to open a drop down box that says paste values only/paste format only/split text to columns https://cdn.discordapp.com/attachments/357648397920108548/621073203711705119/unknown.png .

It works fine in chrome, it works fine in edge, but firefox is a no go, how do I fix this?

I have recently given up my Microsoft office account, and when needing to share a spreadsheet I'm now using Google Spreadsheet though the web browser, but when I try and paste into a google spreadsheet using the right click mouse button menu I get a popup https://cdn.discordapp.com/attachments/357648397920108548/621073069493977088/unknown.png that says copying and pasting in google docs, these actions are unavailable using the edit menus, but you can still use ctrl+c for copy ctrl+x for cut ctrl+v for paste, but when i use the control+v for paste i get and empty cell with a little clipboard menu https://cdn.discordapp.com/attachments/357648397920108548/621073154416050189/unknown.png that I then have to click on to open a drop down box that says paste values only/paste format only/split text to columns https://cdn.discordapp.com/attachments/357648397920108548/621073203711705119/unknown.png . It works fine in chrome, it works fine in edge, but firefox is a no go, how do I fix this?

All Replies (5)

more options

Hi Listatta, unless you are pasting white text onto that white background, I don't know why it's invisible. If you select Paste values only, does the text show up?

Sheets is a complex application, so we often have to live with what Google gives us.

For the most basic pasting, if you double-click the cell and then paste, it should go in as plain text.

But for pasting a range of cells or preserving formatting, the results are less predictable.


By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting:

(1) In a new tab, type or paste about:config in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk.

(2) In the search box above the list, type or paste context and pause while the list is filtered

(3) Double-click the dom.event.contextmenu.enabled preference to switch the value from true to false

Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu.

To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off.

more options

"if you double-click the cell and then paste," paste via right click or paste via ctrl+v doesn't work either way.

so those are not white text on white backgrounds, it's EMPTY.

right click only gives me that stupid pop up window

control+v gives me that empty cell, with the little clipboard icon and it won't paste anything until I click on that little clip board, and then click on format or values, and i can't ever have both, just one or the other, and if I paste value and then try and come back and past format, it erases the previous values.

That it works fine in chrome AND edge, but not in firefox, (tested 2 different computers) with same results is just.....

edge can do it and firefox can't?! without having to re-write the shortcut for all of google docs?!

more options

By the way, you can set Firefox to show its own right-click menu on sites that replace it. Here's where to change the setting:

(1) In a new tab, type or paste about:config in the address bar and press Enter/Return. Click the button promising to be careful or accepting the risk.

(2) In the search box above the list, type or paste context and pause while the list is filtered

(3) Double-click the dom.event.contextmenu.enabled preference to switch the value from true to false

Using Paste on Firefox's menu should still work, even though it doesn't work on Google's custom menu.

To "peel off" Firefox's menu from in front of the site's menu, you can tap the Alt key. It's an individual judgment whether having that menu when you need it justifies the inconvenience of sometimes having to peel it off. </blockquote>

This does not work and only does the following: click right: see attached image below, but there is no paste option ctrl+v: exact same result as before little stupid clipboard icon

more options

so here is a screen capture of something I'm trying to copy: https://cdn.discordapp.com/attachments/617285752450973699/621125354337075201/unknown.png as you can see I've selected that one and I've right clicked and copied

when I go to the new spreadsheet and past via ctrl+v i get: https://cdn.discordapp.com/attachments/617285752450973699/621125312478183443/unknown.png and I have to open the clip board click on values and then finally it gets pasted

more options

Thanks for the example. I don't know why that content is invisible when pasted into Google Sheets. There probably is a difference in how Firefox copies that to the clipboard and how other browsers do it. For example, Firefox doesn't include externally defined styles.

Is the source website a public page you can link to? If not, I guess use a different browser, or look for any other threads about how to work around it on that site.