Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you paste filtered data and prevent hidden cells from receiveing
the data when you 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??
 
highlight the selection-->press F5 key-->click special-->select visible cells
only copy and paste...only visible rows get pasted...
 
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
Possible Autofilter Bug (2003 and 2007) 5
drag data vertically over hidden cells.. ignore hidden cells 1
Filter, Cut and Paste Problem 3
To paste copied data in filtered/visible cells only 1
How do I keep colums hidden when pasting 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
How do I Copy and Paste onto Same Rows after filtering out rows. 2

Back
Top