Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates

I have an Excel file with an external data connection set up. It pulls data in directly from a database, and gives us about 450 rows. The header row allows us to filter the data in the sheet, and we use this as a general purpose tool... I will use the filters to narrow down what I'm looking at based on criteria that change depending on the circumstance.

Often, after filtering the data, I want to send just the filtered records to another person. I'd like to copy/paste just the remaining rows into a new Workbook to send via e-mail. Unfortunately, this doesn't work. When I paste the data, it still pastes all the data. The filtered rows are still in the workbook... they're just hidden. I want them gone from the new file completely.

How can I do this?

share|improve this question

marked as duplicate by MaQleod, Renan, 8088, ChrisF, Nifle Oct 4 '12 at 18:16

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

See my answer to this question. – Scott Oct 3 '12 at 15:33
@Scott Hey, that worked... well enough (had to redo the styling and filters, but that's easy enough). If you post an answer here with the correct name for the alt+; feature, I will accept. – Joel Coehoorn Oct 3 '12 at 15:58
up vote 6 down vote accepted

After filtering the data (i.e., hiding the data you want to exclude),

  1. Select the visible data that you want to export.
  2. Type Alt+;.  This is a shortcut for the Select Visible Cells command, which you can add to your Quick Access Toolbar if you want (look in the “Commands Not in the Ribbon” group).
  3. Copy, and paste into a new workbook.  You’ll get just the visible data.
share|improve this answer
Actually this does not work (the alt + ;). I am on Mac OS. In order to get ; you also have to press Shift. that's ok? – tester Nov 6 '13 at 10:14
Sure, whatever deselects the data that aren’t visible. – Scott Nov 6 '13 at 20:44

Not the answer you're looking for? Browse other questions tagged .