To Hide the rows with cells selected, simply press CTRL 9 (note: pay attention not to click on any cell on the worksheet, otherwise the selection may change) Press CTRL A (the shortcut for Select ALL) make sure to do this inside the result foundĪll cells with Strikethrough (the 9 cells found) are being selectedĬlose the Find dialogue box. The Findings are displayed in the lower part of the dialogue box… In this way, Excel will find only cells with the format your specified, i.e. Go to Font tab –> Check Strikethrough (pls ensure you have select only Strikethrough but no any other format) –> OK (Note: if you want to find cells with strikethrough for a particular column (or range), select the column (or range) beforehand)Ĭlick on Format –> Format… (you may also try “Choose Format From Cell…” if you are looking for specific formats) That’s why I am going to show you the few steps to do it.ĬTRL F to open the Find dialogue box –> click on Options> In Excel 2007 / 2010, we can apply filter by Font colors or Cells colors, that would be great if we can also filter according to other format. The objective is to hide or delete all records (rows) with a strikethrough format. Can you imagine how difficult it is to focus on unfinished jobs?
Tens of hundreds of records (rows) with strikethrough are sitting irregularly in between of records (rows) without strikethrough. In other words, records without Strikethrough are unfinished jobs requiring our attention. Finished jobs were identified by Strikethrough format. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs. Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
0 kommentar(er)
