Related:
- Excel - sort by column specifics, copy rows to new worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Chrome sort bookmarks by date - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel vba add worksheet - Guide
- How to find specific words on a page - 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