Pasting current view

K

karim

Hi,
Does anyone know how I can paste only the current view:
If I have hidden rows or columns and I copy, I want to only paste what is
unhidden.
Same if I have groups and, how I can copy and paste only what is on the
screen (not hidden)
Thanks
Karim
 

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

How do I copy only the unhidden rows/colums? 2
How do I copy & paste only the unhidden data on a worksheet ? 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
macro help 2
copy and paste only unhidden information 2
Copy and Paste with hidden columns remaining hidden 2
Copy, paste 2
How do I keep colums hidden when pasting 1

Top