Related:
- Excel - sort by column specifics, copy rows to new worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Spotify sort by genre - Guide
- Excel date format dd.mm.yyyy - Guide
- How to sort bookmarks in chrome - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
2 replies
Derek32
Posts
2
Registration date
Tuesday March 25, 2014
Status
Member
Last seen
March 25, 2014
1
Mar 25, 2014 at 04:23 AM
Mar 25, 2014 at 04:23 AM
1. Filter the title row, click on the filter button, check the boxes of the items you want to show in your table, say XP. You'll got information which is related to XP only.
This tutorial shows you how to filter data.
https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e?ocmsassetid=ha102840028&ctt=1&correlationid=f37f57e3-91ca-40e9-a823-62ac8feee447&ui=en-us&rs=en-us&ad=us
2. Select the filtered data, copy visible cells only, then you can paste all the filtered information to a new worksheet. You'll got XP information in new sheet.
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e?ocmsassetid=ha010244897&correlationid=49859582-5f61-4080-9cf9-78a9f36ea19c&ui=en-us&rs=en-us&ad=us
This tutorial shows you how to filter data.
https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e?ocmsassetid=ha102840028&ctt=1&correlationid=f37f57e3-91ca-40e9-a823-62ac8feee447&ui=en-us&rs=en-us&ad=us
2. Select the filtered data, copy visible cells only, then you can paste all the filtered information to a new worksheet. You'll got XP information in new sheet.
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e?ocmsassetid=ha010244897&correlationid=49859582-5f61-4080-9cf9-78a9f36ea19c&ui=en-us&rs=en-us&ad=us