Excel Copy and Pasting Cells

Copper Contributor

Anyone else have issues with copying a cell (dotted line around cell), pasting it into a web browser, then copying the information you need and when you paste it into excel it will paste the copied cell that you entered into the browser in the first step? I understand that there is the "Press ESC" process to deselect the initial cell but that seems inefficient and wasn't what it used to be a few months ago. 

9 Replies

@Brian_Song 

If you are experiencing issues with copying and pasting cells in Excel 365, specifically when pasting into a web browser and then copying information back into Excel, here are a few suggestions to try:

  1. Use the Paste Special feature: Instead of using the regular copy and paste commands, try using the Paste Special feature. After copying the cell, right-click on the destination cell in Excel and choose "Paste Special." In the Paste Special dialog box, select the desired paste option, such as "Values," "Formats," or "Formulas." This can help avoid any unwanted carryover effects from the initial copied cell.
  2. Clear the clipboard: Before copying the information from the web browser, make sure to clear the clipboard. In Excel, go to the Home tab, click on the Clipboard group's small arrow at the bottom-right corner, and then click on the "Clear All" button. This ensures that no previous content remains in the clipboard that could interfere with the desired paste operation.
  3. Paste using keyboard shortcuts: Instead of right-clicking and choosing paste, use keyboard shortcuts for pasting. After copying the desired information from the web browser, select the destination cell in Excel and press "Ctrl + V" to paste. This method sometimes provides more control over the pasting process.
  4. Try using a different web browser: If the issue persists with a specific web browser, try using a different one to see if the problem persists. Sometimes, certain browser settings or extensions can interfere with the copy-paste functionality.

@Brian_Song 

I can't reproduce that, all works as expected. Just in case, if to open Windows clipboard (Win+V) do you see in it what was copied both in Excel and on Web page? Assuming clipboard history is ON.

image.png

@NikolinoDE 

1. Tried that but because the initial cell is still selected/dotted, it still pasted the value of the selected cell. 

2. Cleared clipboard, changed option settings, reset the application, turned off the computer (daily), uninstalled and reinstalled, checked add-ons, and still nothing works.

3. I only use keyboard short-cuts (CTRL+C, CTRL+V, Windows+SHFT+S, CTRL+SHFT+UP or DOWN, CTRL+UP or DOWN, ETC.) Trying to avoid hitting ESC to deselect the dotted cell before copying and pasting. 

4. Tried it with Chrome and Explorer, I don't think it's a browser issue.

Yes, I do see the copied text in both Excel Clipboard and WIndows Clipboard (Win+V) but again because the cell I initially copied is selected/dotted, the initial data is pasted in the new cell. Super weird and sudden. Wasn't like this a few months ago.

@Brian_Song 

Is that like this?

Untitled video (1).gif

@Sergei Baklan 

So I attached a .mp4 about it. On my end, after I copy from the browser the dotted cell still remains. Looks like yours gets deselected.

@Brian_Song 

Yes, its' strange. Could be a bug in concrete build, just in case I'm on

image.png

More probable something affects clipboards behaviour. I'd try the same running both Windows and Excel in safe mode.

Perhaps something else, no more ideas.

@Sergei Baklan 

Yeah, that's my guess. I'm currently on the most recent 2305 build. I tested Excel safe mode, and it was the same thing. Under Windows safe mode, I wasn't even able to Open Excel. I reverted out of safe mode and reinstalled/repaired MS Office and still the same. 

 

I tried it under Onedrive view and copy and paste works as it should! So I guess we narrowed it down to the Desktop app having this issue. 

I have a seam problem, do you have a solution?