Keyboard shortcuts not working correctly in Excel Online

Question

Hello.  I have a coworker that is trying to use the shortcut ctrl+shift+v to paste values only in Excel online.  However, it is pasting incorrect values.  For example, if she copies a value of 24.96, and tries to paste the value only, it returns 24.00.  If she tries to copy and paste anything less than 1, i.e. 0.66, it will return 1/0/1900.  If she just copies and pastes the entire cell formatting and all, the correct value gets pasted.

She is working in a shared workbook in Excel Online.  I have tested this out on my name, and I am not having the same problem she is.  I have tried to look through the settings to see if there was anything that I can find, to no avail.

Does anybody have any suggestions on a fix for this?

Answer 1

Waqas,

Thank you again for the response.  I had her try again this morning with ctrl+shift+v and it is back to working correctly now.  I did not have her try to choose the past values from the right click menu.  But, I know 95% of the time when we try to right click and choose paste values from the menu, it pops up with an error box about not being able to access the clipboard and tells us to use the keyboard shortcuts.

Thank you for trying to help resolve the issue.

Mike

Answer 2

Hi Mike,

Thank for writing back with us.  I am very sympathetic to your experience. I do understand the inconvenience it has made and apologize for it.

May I know if problematic user use “paste” option instead of keyboard shortcut key(ctrl+shift+v) does it paste correct value.

Appreciate your patience and understanding.

Best Regards,

Waqas Muhammad

Answer 3

Hi Mike,

Glad to hear this issue has been resolved and thanks for sharing updates with us.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Best Regards,

Waqas Muhammad