Free Add-Ins

Click here to see instructions on how to install our Add-ins

Excel WebToolBar

This is an Excel addin that enables you to quickly log on to your Favourite Excel Web Sites & Forums. There is a even a Search function. Simply type your query into the TextBox and select then Forum of your choice or Google.

The addin is downloaded as an .exe installation file. When the installation is complete a GUI is displayed which will help you correctly install the addin.

After installation, you will find a new item in your Excel Tools Menu - Excel WebToolBar. From this item you can launch the ToolBar or even disable or completely uninstall it.

Click the image above to download.

Calculator

Please try our free Calculator, available now for download. J & R have supplied this Calculator as an Excel Add-In. Our Calculator works very much like the built-in calculator supplied with Microsoft Windows, but because it was designed for use in Excel it has the advantage of being able to: paste results directly into a cell obtain data from a cell to work with Download the free Calculator now!

AddTOC

This addin can be used to quickly & simply add a Table of Contents page to any Workbook. It will also add hyperlinks to the Worksheets. The zip file contains the addin and a workbook that can be used to automate the correct installation of this addin.

Click here to download the addin

JR_DatePicker

The JR_DatePicker is an addin that simplifies adding dates to a cell. It avoids the problems associated with using ActiveX controls in the earlier version by creating it's own DatePicker control. The addin can be called either from the Tools menu or the Right Click Cell Menu. Click on the drop down to display the Calendar, select a date then click the button with the red tick (check)  on to enter the date to the active cell.

•  By default the form opens to the right of the active cell, but can be dragged out of the way with the mouse.
•  With newer versions of MS Excel the form is displayed modeless so that you can select another cell to enter a date, older versions will not allow this.
• The date displayed will be the current date unless you select a cell that already contains a date, in which case it will display the cell entered in that cell.
• Double click on the Enter button to display further features - i.e. change the Format of the Date entered and  change the Format of all Dates in the active sheet - note:. this will not work on Dates entered by Functions like NOW() & TODAY().

Installation is simple. First extract the two files from the zip file to the same folder. Click JR_InstallDatePicker.xls to open it and follow the instructions to install the addin to the correct addin folder. If you use this installer then the addin will be available whenever you open MS Excel.

Check back soon for updates and new utilities

Click here to download the latest version (currently 1.04)

JR_Sheetnavigator Addin: This addin installs a Commandbar with a drop down list of all the visible worksheets in the  workbook. It will update as you add or delete sheets, or change workbooks. It is particularly useful in large workbooks. The zipped file contains the addin & an installer workbook. Extract both workbooks to the same folder. The easiest way to install the addin is with the installer, simply open the JR_InstallAddin.xls workbook & follow the instructions. There is an inbuilt uninstall command if you no longer want to use the addin. Simple help is included.

Click here to download