Cannot paste from elsewhere into a specific table

Occasional Visitor

Hi experts,

This is first time I encounter the problem.


Basically I need to copy and paste a range of values (General format) into column A of a table, right under the last row so that the table may extend automatically.


There is no filter, the format all matches, I can paste the values in any cell BUT the table. Basically what happens is: if I right click I can see all the paste options (as value, etc.), but when I paste, nothing happens, no value is pasted, and I'm sure there is no white color hiding the data from showing.


I have done this hundreds of times but this is the first time. Restart the computer doesn't help.


Another very strange thing is that if I copy values FROM this table into the same table but different places, it doesn't show the same value, it seems that the pasted value is shifted somehow. But there are no formulas, just values. This is VERY VERY annoying as I have to use =Q45 to fetch the value AND I can't paste it back as value.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies