J-Walk Select by Format Add-In

Return to The Spreadsheet Page

Excel page

Excel files

Description:

Have you ever wanted to select cells based on their formatting? If so, the J-Walk Select by Format Add-In is for you. This Excel add-in makes it very easy to select cells based on any or all of the following formatting attributes:

  • Number format
  • Font size, font name, bold, italic, or font color
  • Horizontal or vertical alignment
  • Background color and shading

This add-in is fully functional, not crippled, and has no nag messages. It's absolutely free, with no strings attached.

Rated 5-stars by the ZDNet Software Library.

selbyfmt.gif (5322 bytes)

Download

Click the link below to download the add-in.

How it works

Start by selecting a cell that contains some or all of the formatting attributes that you want to select. The Select by Format dialog box (shown below) displays the formatting of the active cell as a series of check boxes. Place a checkmark next to the attribute(s) that you want to include in the search and click OK. The result? All matching cells on the worksheet are selected. Once selected, you can do what you like with the cells: format them, delete them, assign a name, create a named style, etc..

In the dialog box shown above, the user has selected two attributes. The add-in will search for all cells that (a) match the active cell's numeric format (which happens to be percent, with one decimal place) and (b) match the active cell's interior color and shading. You can select any number of the checkboxes.

If your worksheet has many cells, you can select the Show progress bar check box. Doing so will display a handy progress indicator -- but using the progress bar will also slow down the selection just a bit.

Installation:

  1. Download the J-Walk Select by Format add-in (it's a self-extracting EXE file).
  2. Extract the XLA add-in file by double-clicking the SELBYFMT.EXE file.
  3. Start Excel and select the Tools - Add-Ins command. Don't even try using it with previous versions of Excel.
  4. In the Add-Ins dialog box, click the Browse button and locate selbyfmt.xla (the file you extracted in Step #2).
  5. Click OK
  6. Activate your workbook.
  7. Select Tools - Select by Value from the menu.