Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Excel Easy Search/Find by Format

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Tools for Excel Tables Start

Easy search - By format  
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.
The selected range is automatically detected as the search range.
If that is not the range to be searched, you may choose another manually.
3. Finally, decide which sheets contain the same range to be searched.



4. Now, choose the search mode. In this example, choose Search By Format
5. We have to choose the cell with the background color of the cells to be searched.



Finally, decide what to do with the data, namely:
a. Select the cells meeting the criteria
b. Do mathematical operations with resulting cells.
c. See search statistics
d. Browse within resulting cells
e. Print an Easy Search report.

Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us