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
Gantt Chart Demo
Category: General Files | [Item URL]
- Description: Demonstrates how to create a "time line" (Gantt) chart in Excel. This type of chart is often use to depict various tasks in a project.
- Has Macros? No
- Download: gantt.xls
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
Keno For Excel
Category: General Files | [Item URL]
- Description: Of all the popular gambling games, none has worse odds than Keno. If you don't believe it, try your hand at this Excel implementation.
- Has Macros? Yes
- Download: keno.xls
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
AcitveX Control Demo
Category: Developer Files | [Item URL]
- Description: Demonstrates the use of ActiveX controls on a worksheet.
- Has Macros? Yes
- More Information: Click here
- Download: controls on sheet.xls
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: