Related:
- Excel - sort by column specifics, copy rows to new worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- How to sort bookmarks in chrome - Guide
- Spotify sort by genre - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
2 responses
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
