ExcelBanter - To paste copied data in filtered/visible cells only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - To paste copied data in filtered/visible cells only (https://www.excelbanter.com/excel-discussion-misc-queries/226513-paste-copied-data-filtered-visible-cells-only.html)

Hamad

To paste copied data in filtered/visible cells only

Is there a way to paste copied data only in the visible/filtered cells in a
worksheet and not also in the hidden cells. as MS Excel 2007 usually does it?

Sheeloo[_5_]

To paste copied data in filtered/visible cells only

Before pasting press F5, click on Special and choose the option 'Visible
cells only'

"Hamad" wrote:

Is there a way to paste copied data only in the visible/filtered cells in a
worksheet and not also in the hidden cells. as MS Excel 2007 usually does it?

All times are GMT +1. The time now is 09:29 AM.