Pasting on Filtered Data Sheets without pasting onto hidden cells

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

Guest

How do you paste onto filtered data and prevent hidden cells from receiveing
the data when you paste.
 
Can you sort the unfiltered data by some key that groups the rows you want
together?

Then you could paste and sort back to the original order.

There's nothing built into excel that does what you ask.
 
You must log in or register to reply here.

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

Paste 3
drag data vertically over hidden cells.. ignore hidden cells 1
How do I Copy and Paste onto Same Rows after filtering out rows. 2
To paste copied data in filtered/visible cells only 1
Possible Autofilter Bug (2003 and 2007) 5
How to paste data over the hidden rows in a sheet with a filter 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
pasting data on hidden cells 2

Back
Top