Excel – ‘Find & Select’ to Change Formatting of Multiple Cells at Once
Using the ‘Find & Select’ feature you can locate and select multiple cells at once. This will allow you to make changes to the cells as a group. In this example we will find a group of cells with the same formatting and change the formatting all at once. The images shown are from Excel 2010, the process is the same in Excel 2007.