Paste

G

Guest

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

Dave Peterson

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??
 
G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting on Filtered Data Sheets without pasting onto hidden cells 1
drag data vertically over hidden cells.. ignore hidden cells 1
Filter, Cut and Paste Problem 3
Possible Autofilter Bug (2003 and 2007) 5
To paste copied data in filtered/visible cells only 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
How do I keep colums hidden when pasting 1
MSExcel 2007 Filters do not allow Copy and Paste of data 2

Top