Forum Discussion
filter by strikethrough
Manchester05 1. Select any cell in the spreadsheet, then click the "Home" tab. Click the "Find and Select" button and choose "Find" from the menu that appears.
2. Click "Options," then click the "Format" button.
3. Click the "Font" tab. Click the box next to "Strikethrough" to place a check in it, then click "OK."
4. Click "Find All" and a list of every cell that contains strikethrough text will appear at the bottom of the Find and Replace window.
5. Click on the name of a cell in the list to jump to that cell in the spreadsheet. Click the "Find All" button again to refresh the list if you alter the text in a cell to remove the strikethrough.
That's okay, but not exactly filtering. Assume you have multi-column range with few hundreds of rows and want to work only with few rows which are marked by strikthrough text in first column. Find by Format only selects such cells.
- Indeed, it isnt filtering, so thats a hassle in big data
