Excel Files: General


Return to The Spreadsheet Page

Excel page

User tips

Developer tips

Excel FAQs

Excel files

Excel Expert E-Letter

Excel Help Resources

Excel links

Excel oddities

Excel books

Power Utility Pak for Excel


Free Downloads

The files listed below may be useful for all users.

NOTE:
These files are all self-extracting EXE files. To unpack them, just execute the file. After the file is extracted, you can delete the EXE file.

Indicates a popular download.
File Excel Version Size Link

Climate Data Workbook

An interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros.

97 and later 320K More Info

Gradient Contour Chart Add-In

An add-in that generates an alternative to Excel's contour chart. Charts produced by this add-in are not dynamic.

97 and later 335K

More Info

J-Walk Chart Tools

A collection of chart-related utilities.

97 and later 347K

More Info

J-Walk Enhanced Data Form Add-In

Version 2.0. An alternative to Excel's Data * Form command. Lots of enhancements, and the VBA source code is available (for a small fee) so you can customize it.

97 and later 353K

More Info

Animated Hypocycloid Charts 

An Excel workbook that generates an infinite number of dazzling animated charts. You will be impressed. 

97 and later 333K

More Info

Power Utility Pak v6

A collection of Excel utilities, functions, and enhanced shortcut menus.

2000 and later 2354K More Info

Dice Roller

An Excel workbook that simulates rolling two dice.

97 and later 289K

More Info

Toolbar Calculator 

An Excel add-in that creates a toolbar that functions as a simple calculator.

97 and later 144K

More Info

Clock Chart 

An Excel workbook that contains an XY chart that displays a working analog clock. It uses a VBA macro to update the chart every second.

97 and later 107K

More Info

Employee Time Sheet

Easy-to-use time sheet for tracking daily hours worked.

5 and later 41K

More Info

ActiveX Control Demo

Demonstrates the use of ActiveX controls on a worksheet

97 and later 110K

More Info

J-Walk Cell Math Add-In

An add-in that enables you to perform any mathematical operation on cells without using formulas. An enhanced version of this utility is available in PUP v5.

97 and later 181K

More Info

Children's Multiplication Exercises

Assists in learning multiplication tables. Contributed by Jim Hubbard. Instructive for children and adults who are learning VBA.

97 and later 121K Download

AddPath Add-in

An add-in that enables you to print a workbook's full path in a header or footer.

97 and later 70K

More Info

Extended Date Functions

An add-in that provides a set of worksheet functions that enable you to work with dates prior to the year 1900 -- something that's not normally possible. These functions are also available in PUP v5.

97 and later 76K

More Info

J-Walk Date Report Add-In

An add-in that generates a useful report that describes all date cells in a worksheet. This may help you identify potential Year-2000 problems. An enhanced version of this utility is available in PUP v5.

97 and later 74K

More Info

J-Walk Select by Format Add-In

An add-in that enables you to select cells based on formatting. For example, you can easily select all cells that contain a specific number format and are red. An enhanced version of this utility is available in PUP v5.

97 and later 70K

More Info

Keno for Excel 97

A worksheet that simulates a Keno game. Just like the casinos - except you won't lose any money with this version.

97 and later 74K

More Info

J-Walk Conditional Row Delete

An add-in that makes it easy to delete rows based on the values in a specified column. 

97 and later 73K

More Info

Timeline Chart

Demonstrates how to create an attractive "time line" (Gantt) chart in Excel.

5 and later 42K Download

Name Lister Add-In

An add-in that displays a list of names in a workbook by category (all names, workbook level names, sheet level names, hidden names, linked names, and "bad" names). An enhanced version of this utility is available in PUP v5.

97 and later 68K

More Info

 

Superscript / Subscript Formatting Add-In

An add-in that enables you to add superscript or subscript formatting to characters within a cell. An enhanced version of this utility is available in PUP v5.

97 and later 74K

More Info

Tony Gwynn's Hit Database

An Excel database with information about Tony Gwynn's first 3,000 hits. Use the pivot table to summarize the data in various ways. (Tony Gwynn is a baseball player on the San Diego Padres.) 

5 and later 315K Download

Menu Shenanigans

Makes a great April Fool's prank for an office-mate (preferably one with a sense of humor). VBA macros reverse the text in all of Excel's worksheet menus. The hot keys remain intact, so the menus can still be accessed using familiar keystrokes.

97 and later 56K Download

Appointment Calendar Maker

A workbook that lets you generate and print daily appointment calendar pages. 

5 and later 47K

More Info

Guitar Scales and Modes

This workbook features a graphic depiction of a guitar fretboard, and displays the fret locations for the notes in any scale or mode, in any key you choose. 

5 and later

 

62K Download
 

Excel Doodle Pad

Etch-a-Sketch with a new twist.This workbook displays a doodle pad that lets you create attractive symmetrical drawings using the arrow keys on your keyboard. 

5 and later 46K Download

Array Calendar

Demonstrates how to create a calendar for any month using a single (complex) array formula.

5 and later 42K Download

Another Gantt Chart

This one was featured in John Walkenbach's PC World column.

5 and later 38K Download

Hangman Game

The classic word-guessing game, programmed in VBA - complete with cheesy hand-drawn graphics. Includes many words, and you can even add your own. A much better version of this game is available in PUP v5.

5 and later 68K Download

Custom Number Format Examples

This workbook contains several examples of useful custom number formats.

5 and later 43K Download