 | |
| Excel's Find and Replace (surprising features) |
Use Excel's Find and Replace feature to not only find and select all cells, but to also find and replace cell formatting. You can use Excel's shortcut keys Control + F to get to the FIND dialogue box and Control + H to get to the replace dialog box. You can search for a specific text in formulas, cells and also comments.
You have the option to search inside the entire workbook or a specific worksheet. You can get more advanced with Excel's find and replace feature by searching for a specific cell formatting and replacing it with another. For example, you need to replace one cell color with another color. You can quickly do that with Find and Replace.
Related Topics:
Post a Comment