Workbook Taskbar Add-In
Category: Add-Ins | [Item URL]
- Description: This add-in displays a toolbar that makes it easy to switch among all active workbooks. It is compatible with Excel 97 through Excel 2003. Note that this add-in may not work properly with other files that use event procedures.
- Has Macros? Yes
- Download: taskbar.xla
Speech Control Ribbon Enhancement
Category: Add-Ins | [Item URL]
- Description: Install this add-in, and you'll have a new group on the Review tab of the ribbon: Text to Speech. Use these controls to read the contents of cells.
This add-in does not work with versions prior to Excel 2007.
- Has Macros? Yes
- More Information: Click here
- Download: speechcommands.xlam
Superscript / Subscript Formatting Add-In
Category: Add-Ins | [Item URL]
- Description: Simplifies individual character formatting for superscript, subscript, bold, italic, and font size. A more sophisticated version if available in Power Utility Pak.
- Has Macros? Yes
- Download: supersub.xla
Name Lister Add-In
Category: Add-Ins | [Item URL]
- Description: The Name Lister add-in displays a list of all names in a workbook, by category (Workbook level, Sheet level, Hidden, Linked, and Invalid). The add-in also lets you delete names and activate named ranges interactively without closing the Name Lister dialog box. A more sophisticated version is available in Power Utility Pak.
- Has Macros? Yes
- Download: namelist.xla
Conditional Row Delete Add-In
Category: Add-Ins | [Item URL]
- Description: This add-in makes it very easy to delete rows based on the values in a specified column. For example, you can delete all rows that contain a value between 0 and 12 in Column F.
- Has Macros? Yes
- Download: rowdel.xla
Select By Format Add-In
Category: Add-Ins | [Item URL]
- Description: The J-Walk Select by Format Add-In makes it very easy to select cells based on their formatting attributes. It's a much less sophisticated version of the utility in my Power Utility Pak.
- Has Macros? Yes
- Download: selbyfmt.xla
Date Report Add-In
Category: Add-Ins | [Item URL]
- Description: The J-Walk Date Report add-in can help you identify such problems. The add-in generates a worksheet database report that describes each date cell in a worksheet. This was really popular in late 1999 when people were worried about the "Y2K problem.
- Has Macros? Yes
- Download: datereport.xla
Extended Date Functions (XDATE)
Category: Add-Ins | [Item URL]
- Description: Excel cannot work with dates prior to the year 1900. The Extended Date Functions add-in (XDATE) corrects this deficiency, and allows you to work with dates in the years 0100 through 9999.
- Has Macros? Yes
- More Information: Click here
- Download: xdate.zip
Cell Math Add-In
Category: Add-Ins | [Item URL]
- Description: The Cell Math add-in provides an easy way to modify cells without using formulas. Some of the functionality of Cell Math is available through Excel's Paste Special command (using the Add, Subtract, Multiply, or Divide option), but Cell Math is much more versatile and easier to use.
- Has Macros? Yes
- Download: cellmath.xla
Toolbar Calculator
Category: Developer Files / Add-Ins | [Item URL]
- Description: An add-in that displays a new toolbar that functions as a simple calculator.
- Has Macros? Yes
- More Information: Click here
- Download: calculator toolbar.xla
Excel Downloads
This section contains free Excel workbooks and add-ins. With a few exceptions, all of these files were developed by me -- John Walkenbach. Some of the files demonstrate useful techniques that you can adapt to your own work. Others are simply for fun.
The files are grouped into three categories: General Interest, For Developers, and Add-Ins. The files may not be compatible with all versions of Excel.
All Downloads
Browse Downloads by Category
Also of Interest
How to download
Most of the download links point directly to Excel files, but a few are compressed ZIP files. For best results: