ExcelBanter - Paste

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

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

- - Paste (https://www.excelbanter.com/excel-discussion-misc-queries/162182-paste.html)

Tavo

Paste

How do you paste filtered data and prevent hidden cells from receiveing
the data when you paste.

Dave Peterson

Paste

You don't.

Maybe you can sort the range that's filtered by some key field and put all the
cells that are going to be pasted in a contiguous area??

Tavo wrote:

How do you paste filtered data and prevent hidden cells from receiveing
the data when you paste.

--

Dave Peterson

Nikki

Paste

highlight the selection--press F5 key--click special--select visible cells
only copy and paste...only visible rows get pasted...

"Tavo" wrote:

How do you paste filtered data and prevent hidden cells from receiveing
the data when you paste.

Excel_Learner

Paste

filter your data. Select the data and press F5 and click on special and
select visible cells only and copy the data and paste it.

"Nikki" wrote:

highlight the selection--press F5 key--click special--select visible cells
only copy and paste...only visible rows get pasted...

"Tavo" wrote:

How do you paste filtered data and prevent hidden cells from receiveing
the data when you paste.

All times are GMT +1. The time now is 09:02 PM.