How do I copy a filtered subset of data to another worksheet?

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

Guest

I am trying to develop a series of analysis from a major worksheet. I need
to capture as a report each of the subsets of data for a snapshot of today's
work. When I try to copy - the Clipboard, of course, copies everything,
including the hidden data. I know there is a way to copy just what is
visible but I can't remember and can't find any reference in any help files.
Anyone?
 
To display on the visible cells when doing a copy & paste, perform the
following:
Select View, Toolbars, Customize, and then select the Edit category and
drag/place the "Select Visible Cells" icon on your toolbar. Then highlight
the section of cells that you want to copy, click on the "Select Visible
Cells" icon, and then copy (control + c). Place your cursor on the cell or
worksheet that you would like to paste the visible cells onto, and paste
(control + v). This should do 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

Cannot copy worksheet to another file 2
Select Subset of Rows/Cols 1
How do I save a filtered subset of a worksheet? 2
Subset of table data on another worksheet 1
Nested "filters" of a list 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying (and protected worksheets) 1
To paste copied data in filtered/visible cells only 1

Back
Top