In those 5 cells, only two were chocolate chip orders, so those are the only two that I saw, when the list was filtered. They weren’t pasted into the visible rows though – they were pasted into a block of 5 cells, starting with cell E6, where I pasted the data. What happened to the other 3 dates that I pasted? When I cleared the filter on the list, I could see that all 5 dates were there. However, only 2 of the dates were pasted. In the screen shot below, I selected 5 cells in column B, and pasted them into the same rows in column E. Pasting data into a filtered list can quickly turn into a big mess, and you’ll end up overwriting some of your data. But you can have a serious problem pasting in Excel filtered list. Then, copy data from one column, and paste it into another. It looks like a simple task – filter a list, so you an see the items you’re interested in.
0 kommentar(er)
