Problem with Excel pasting into filtered cells

[bkoopers]

I am using Office 365, Excel version 2501.

When viewing a filtered spreadsheet, I encountered an unexpected behavior. If I copy one cell and then highlight a group of consecutive cells in another filtered column and paste, it pastes what I copied in those highlighted cells but if I highlight and copy consecutive cells in a column and paste them in consecutive cells in another filtered column, instead of pasting into only the visible cells, it pastes into any hidden cells that are in the range counting from the first cell.

I would have lost data if I did not realize right away that this happened and selected an "Undo". Why does it paste into those hidden cells? How can I have it paste only into visible cells?

I saw in an old post from 2003 that somebody said to select "visible cells only" but the directions given does not apply to the current version of Excel.

 

[combo]

It's just an Excel feature, hidden rows have still data and can be referenced in other cells.
It seems that Excel copies visible cells. There are possibilities (copy & paste in filtered range):

• single cell copied, single cell selected to paste: trivial,
• single cell copied, range selected (continuous or not) to paste: copied to visible cells in selection
• range (continuous or not) copied, single cell selected to paste: copied to continuous range, incl. hidden cells,
• range copied, range selected to paste: work only if there are no hidden rows in copied range, copied range is pasted to each cell in selected range as in case 3.

So, when you need to change filtered data, work with single cells only .