copy and paste range of cells excluding hidden data in excel

  • Thread starter Thread starter Steve22055
  • Start date Start date
S

Steve22055

Is anyone aware of a way to copy a range of data that includes hidden rows
but when pasting into another workbook excludes the hidden data and only
pastes the visible data from the originating file?
 
Make sure that both workbooks are open in the same instance of excel.

Then do the copy|paste.

If you're hiding rows manually (or via autofilter in xl2007), you may want to
select the visible cells first.

Select the range to copy
hit F5 or ctrl-g
Special|visible cells only
Then do the copy|paste
 
Dave, Thanks for the quick response. Your help could be the edge I need in
being hired. The director asked me this question in the interview process.
Thank you again for your help!!!
 
Good luck!
Dave, Thanks for the quick response. Your help could be the edge I need in
being hired. The director asked me this question in the interview process.
Thank you again for your help!!!
Click to expand...
 

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

Copy/Paste with Hidden Rows/Columns Excel 2007 3
paste excel sheet excluding hidden rows 3
drag data vertically over hidden cells.. ignore hidden cells 1
copy hidden sheet data 2
Not include hidden columns in copy paste 2
To paste copied data in filtered/visible cells only 1
Copy and paste - filtered data 2
Copy and Paste with hidden columns remaining hidden 2

Back
Top