Selecting and manipulating data from a sorted and filtered table

**fdlamp** · 05-05-2011, 11:03 AM

I have a table with 15 columns and over 35000 rows. I used MS query to extract this information from our database. With the proper filters in place, the majority of the rows are hidden with about 10,000 remaining. How can I copy, select, separate, etc... the remaining values to a separate sheet? When I copy the table and paste values only on a separate sheet, it ends up pasting the entire table including the hidden cells.

Thanks.

Edit: Just for clarification, the data is currently held in a table.

**Mandy11** · 05-10-2011, 02:11 AM

You tried copying then clicking Edit, Paste Special and then click the radio button for Values.

Hope this helps.

**arasan25** · 05-10-2011, 04:41 AM

You could use the command "Select Visible Cells" (you can find it from Excel Options- Customize). Highlight your spreadsheet, click on this command and paste in a new sheet only visible cells are copied.

Hope it works out.

Cheers

Arasan