Forum Discussion
p_d_hodgson
Apr 16, 2025Copper Contributor
Excel Table bug - Copy and Paste
OK, let's vote on whether you think this is a bug!
Create a spreadsheet
Enter 'Number' in A1, and 'Reverse' in B1
Enter the formula '=IF(A3="",1,B3+1)' in B2
Select A1:B2 and Format as Table (any formatting you like).
Enter 1 in D2, 2 in D3, and 4 in D4
Individually, copy D2 to A2, then D3 to A3, the D4 to A4
You end up with a table with 1,2,3 in A2:A4 and 3,2,1 in B2:B4
Undo the copy/pastes, then select D2:D4 and copy/paste to A2:A4
Do you get a different result???
Do you think this is a bug?
1 Reply
Weird - you can report it from within Excel:
Help > Feedback > Report a problem.