Filtered out cells are overwritten at copy and paste

Symptoms

Please consider the following scenario:

1. Launch Excel.
2. Enter the following data in cells A1:C5:


Please note that the initial value of the B4 is 50.

3. Filter the column Color to show only Red.In column X only to values are shown, 20 and 40.
4. Select the cell with the values 20 and 40, B3 and B5, and press Ctrl+C.
5. Select the cell C2 and press Ctrl+V.Only the value 20 is shown.
6. Modify the filter to show all the colors.


Result:
The value 50 in cell B4 was replaced by value 40.


Cause

This is by design.

Resolution

Please remove the filter before copying and pasting data.

More Information

This information can be found in the Help file for Excel found here http://office.microsoft.com/client/helppreview14.aspx?AssetId=HA010342322&lcid=1033&NS=EXCEL&Version=14&tl=2&respos=0&CTT=1&queryid=39d6719a9ac94ca0bd891adeae79a91f

Notes
  • Excel pastes the copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might need to unhide the paste area to see all of the copied cells.

Thuộc tính

ID Bài viết: 2409781 - Xem lại Lần cuối: 17-05-2012 - Bản sửa đổi: 1

Phản hồi