Access ¨ Excel ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨ Word ¨ Miscellaneous ¨ Tutorials ¨ Windows
Free Downloads
¨
Suggest an Article
¨
Fix an Article
|
|
Viewed times since 11 June 2005
Please report any broken links immediately so we may keep this resource up to date!
If you would like your download listed here, or even uploaded here for download, forward it to downloads@officearticles.com and we'll be happy to upload it and list it for you. Please include how you'd like to be recognized for your contribution.
You can get Microsoft's templates at Microsoft's Office site. Once there, just click on templates and do a search.
Check our own downloads folder; we are constantly adding new things, some of which relate to articles found here on our site. You can see our downloads at www.officearticles.com/downloads. Our free downloadable files and templates include:
|
# |
App |
Name of Download |
Description |
Website/Link |
|
|
1 |
Excel |
Climate Data Workbook |
An interactive charting workbook that lets you compare the climate of two U.S. cities. It uses no macros. |
||
|
2 |
Excel |
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. |
||
|
3 |
Excel |
J-Walk Chart Tools |
A collection of chart-related utilities. |
||
|
4 |
Excel |
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. |
||
|
5 |
Excel |
Animated Hypocycloid Charts |
An Excel workbook that generates an infinite number of dazzling animated charts. You will be impressed. |
||
|
6 |
Excel |
Power Utility Pak v6 |
A collection of Excel utilities, functions, and enhanced shortcut menus. |
||
|
7 |
Excel |
Dice Roller |
An Excel workbook that simulates rolling two dice. |
||
|
8 |
Excel |
Toolbar Calculator |
An Excel add-in that creates a toolbar that functions as a simple calculator. |
||
|
9 |
Excel |
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. |
||
|
10 |
Excel |
Employee Time Sheet |
Easy-to-use time sheet for tracking daily hours worked. |
||
|
11 |
Excel |
ActiveX Control Demo |
Demonstrates the use of ActiveX controls on a worksheet |
||
|
12 |
Excel |
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 v6. |
||
|
13 |
Excel |
Children's Multiplication Exercises |
Assists in learning multiplication tables. Contributed by Jim Hubbard. Instructive for children and adults who are learning VBA. |
||
|
14 |
Excel |
AddPath Add-in |
An add-in that enables you to print a workbook's full path in a header or footer. |
||
|
15 |
Excel |
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. An enhanced version of this utility is available in PUP v6. |
||
|
16 |
Excel |
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 v6. |
||
|
17 |
Excel |
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 v6. |
||
|
18 |
Excel |
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. |
||
|
19 |
Excel |
J-Walk Conditional Row Delete |
An add-in that makes it easy to delete rows based on the values in a specified column. |
||
|
20 |
Excel |
Timeline Chart |
Demonstrates how to create an attractive "time line" (Gantt) chart in Excel. |
||
|
21 |
Excel |
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 v6. |
||
|
22 |
Excel |
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 v6. |
||
|
23 |
Excel |
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) |
||
|
24 |
Excel |
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. |
||
|
25 |
Excel |
Appointment Calendar Maker |
A workbook that lets you generate and print daily appointment calendar pages. |
||
|
26 |
Excel |
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. |
||
|
27 |
Excel |
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. |
||
|
28 |
Excel |
Array Calendar |
Demonstrates how to create a calendar for any month using a single (complex) array formula. |
||
|
29 |
Excel |
Another Gantt Chart |
This one was featured in John Walkenbach's PC World column. |
||
|
30 |
Excel |
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. An enhanced version of this utility is available in PUP v6. |
||
|
31 |
Excel |
Custom Number Format Examples |
This workbook contains several examples of useful custom number formats. |
||
|
32 |
Excel |
MP3 File Lister |
A macro-driven application that creates an attractive listing of MP3 music files. |
||
|
33 |
Excel |
A Class Module to Manipulate a Chart Series |
A useful class module that makes it easy to work with the data used by a chart. |
||
|
34 |
Excel |
Soundex Demo |
Demonstrates a technique that lets you search for a text based on its sound. |
||
|
35 |
Excel |
GetOption Function |
Demonstrates a useful function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly. |
||
|
36 |
Excel |
Control the LED Display in the StatusBar |
Originally developed by
David Wiseman. It consists of VBA code that lets you control the "LED"
display in Excel's status bar. I've always thought that this display was
off limits, but David proved otherwise with some incredible programming.
Very impressive! Thanks to David for letting me share this file with the
world, and thanks to Jim Rech for modifying it so it works with Excel
2000. |
||
|
37 |
Excel |
UserForm Hyperlink Demo |
Demonstrates how to add hyperlinks to a UserForm Click |
||
|
38 |
Excel |
J-Walk FaceID Identifier Add-In |
Makes it very easy to determine the FaceID value for a CommandBar image. |
||
|
39 |
Excel |
Charts in a UserForm |
Demonstrates how to display one or more charts in an Excel 97 UserForm. |
||
|
40 |
Excel |
Menu Maker |
A technique that makes it very easy to create a custom menu for an Excel 97 (or later) workbook or add-in. VBA programming not required! |
||
|
41 |
Excel |
Displaying Online Help |
A technique that makes it easy to display help topics in a UserForm. |
||
|
42 |
Excel |
A Color Picker Dialog Box |
Demonstrates a custom VBA function that displays a UserForm that lets the user select a color. Uses a class module. |
||
|
43 |
Excel |
Filling a ListBox With Unique Items |
A clever technique to fill a ListBox with non-duplicated items in a list. |
||
|
44 |
Excel |
Handle Multiple UserForm Buttons With One Procedure |
With an Excel 97/2000 UserForm, each control on the form has its own unique Click event, so you can't have several buttons that call the same Sub procedure. This workbook demonstrates a way around this limitation by using a class module. |
||
|
45 |
Excel |
ImageMap Demo |
Demonstrates how to create a clickable image map for navigation within a workbook. |
||
|
46 |
Excel |
||||