Select Excel spreadsheet cells with the same format by one click

Advanced Excel Select

If you have ever tried to find cells containing conditional formats, formulas, comments, etc. you would highly appreciate this add-in.

Advanced Excel Select is an add-in for Microsoft Excel 2003, Excel 2002 (XP), and Excel 2000.

Setup file

850 KB

Advanced Excel Select in detail

If you ever tried to find cells containing conditional formats, formulas, comments, and such, you would appreciate Advanced Excel Select at its true value. Just two clicks to have the job done! It also introduces a feature useful in fast table formatting: Select by Format.

Save your time and nerves with Advanced Excel Select:

• A single dropdown menu on a toolbar;
• Select rows and columns that have the same format with the button on a toolbar;
• Simple installation and clean uninstallation.

Pop-up menu

Advanced Excel Select options

Advanced features

Select the cell that contains formatting you want to select. Do one of the following:

• 
  
  
  To select all adjacent cells in the current row that contains the same formatting as the current cell - click the Smart Row Select button on the toolbar.
• 
  
  
  To select all adjacent cells in the current column that contains the same formatting as the current cell - click the Smart Column Select button on the toolbar.

Tip: These features are especially useful when formatting tables.

How to select in just one click

That's easy.

1. Press the mouse button down while the mouse pointer is over the Advanced Excel Select button on the toolbar.
2. Move the mouse to the required menu item.
3. Release the mouse button.

Download Advanced Excel Select

• Setup file (850 KB)

See also in "Excel - Find / Select Excel data"

• Merge Tables Wizard for Excel - Copy matching data from lookup Excel table to main one.
• Advanced Find & Replace for Excel - Find and Replace in all opened Excel workbooks & worksheets.