King James Bible
Category: General Files | [Item URL]
- Description: Version 2, for Excel 2007 and later. Not to be confused with the Excel Bible, by yours truly. This is the King James Bible in an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell. Features: a hyperlink table of contents,summary formulas to calculate key stats for each book, a word count feature, a random verse generator, and a spiffy new Ribbon interface. If you use a version before Excel 2007, here's the old version.
- Has Macros? Yes
- Download: king-james-bible.xlsm
Word Clock
Category: General Files | [Item URL]
- Description: Based on a screen saver by Simon Heys. It displays the current date and time in words, updated every second. Completely useless, but you might find it interesting. For Excel 2007 and later.
- Has Macros? Yes
- Download: word clock.xlsm
Generate Meeting Bingo Cards
Category: General Files | [Item URL]
- Description: Generate meeting bingo cards to liven up boring meetings. Contains 186 buzzwords, randomly arranged in a 5x5 grid. Or, customize this file for other types of bingo games (such as political speeches).
- Has Macros? No
- Download: meetingbingo.xls
Functions To Quantify Color Contrast
Category: General Files / Developer Files | [Item URL]
- Description: This workbook contains VBA functions that can help you select legible colors for cell background and text.
- Has Macros? Yes
- More Information: Click here
- Download: color-difference.xls
Excel 2007 Function List
Category: General Files | [Item URL]
- Description: An Excel 2007 workbook that contains a list of all worksheet functions, in a table. Each function has a brief description and a hyperlink to its help topic at Microsoft's site. This file was accidentally omitted on the CD-ROM that accompanies my Excel 2007 Formulas book.
- Has Macros? No
- Download: worksheet functions.xlsx
Generate A Word Frequency List
Category: General Files / Developer Files | [Item URL]
- Description: A workbook that demonstrates a VBA macro that creates a word frequency list. Put your text in Column A, with no blank cells. The text can consist of sentences, titles, etc. Run the macro, and you get a pivot table that lists every word, and the number of times it's used. The demo file contains three examples: Beatles song titles, the first few paragraphs of Moby Dick, and a George W. Bush speech.
- Has Macros? Yes
- More Information: Click here
- Download: wordfrequency.xls
Display Disk Drive Information
Category: General Files / Developer Files | [Item URL]
- Description: Contains VBA macros that display information about the drives attached to your system. It uses three functions: DriveType, DriveSize, and DriveSpaceFree.
- Has Macros? Yes
- More Information: Click here
- Download: driveinfo.xls
Slide Show Demo
Category: General Files / Developer Files | [Item URL]
- Description: Demonstrates a simple VBA macro that displays a full-screen slide show of all embedded charts on a worksheet.
- Has Macros? Yes
- More Information: Click here
- Download: chart slide show.xls
Yearly Calendar - With Holidays
Category: General Files | [Item URL]
- Description: An enhanced version of this workbook. U.S. holidays are highlighted, using conditional formatting.
- Has Macros? No
- Download: yearly-calendar-with-holidays.xls
Yearly Calendar Workbook
Category: General Files | [Item URL]
- Description: A worksheet that displays a yearly calendar for any year between 1900 and 2100. Use the slider at the top to select the year. Change the appearance by modifying the named styles.
- Has Macros? No
- Download: yearly-calendar.xls
[Next page]
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: