Wednesday, December 21, 2011

How to Find Cells With Strikethrough in Excel


1. Open Microsoft Excel. Hold the 'Control' key and press the 'F' key on the keyboard. The combination opens the'Find' function.
2. Click on the 'Format' button in the 'Find and Replace' window. Click on the 'Fonts' tab.
3. Check the 'Strikethrough' checkbox in the 'Effects' section and click the 'OK' button.
4. Click the 'Find all' button in the 'Find and Replace' window.
5. Look at the bottom of the 'Find and Replace' window. All the cells with 'Strikethrough' are listed at the bottom of the window.

Blogger news