Current Version: Version 3.0

Compatibility: PC Only | Excel 2007 or later (including Office 365 Desktop) | Works on 32-bit or 64-bit

License: 1 per user

help-page: Tickmark Help Page

Tickmark Add-in for Excel

Understand And Audit Spreadsheets With Ease!

The Tickmark Excel Add-in is a tool geared to help analysts understand, audit, or explain spreadsheets easier. This add-in was built to help all users of Microsoft Excel alleviate the painful process of getting handed another person's spreadsheet model and needing to understand it, improve it, or audit it quickly and effectively.

Bulk Discounts For Your Organization

Buy Tickmark for your whole team, department, or company and save! The discounted price will be applied automatically during your checkout process.

  • 5-9 units per single order --> 10% off the total cost

  • 10+ units per single order --> 15% off the total cost

Insert Variety of Tickmark Icons

Add Tickmarks To Your Spreadsheet

Add various tickmark symbols to your spreadsheet with a click of a button. The icons available in the add-in include:

  • Popular Symbols

  • Numbering 1-99

  • Letters A-Z

  • Various accounting abbreviations

Instantly Remove Your Tickmarks

Need to start over or clean up the spreadsheet? Use the Remove Ticks button to remove all the tickmarks added to the active spreadsheet.

Example of tickmarks on a spreadsheet

Choose Your Own Colors!

You can choose to insert your tickmarks as pictures or shapes. If you choose the "shapes" option, you are free to change the fill color as you would any other Excel shape. If you want a specific color by default, you can set preferred color formats for most of the tickmark icons in the Settings Userform using RGB color codes.

Custom Tickmark Colors
Create Your Own Tick Icons

Everyone is Different, So Create Your Own!

While the Tickmark add-in comes with pre-built Tick icons for you to use, the tool also gives you the ability to create up to 30 of your own Tickmark icons. Simply import a picture into your spreadsheet or create your own icon from scratch using Excel shapes and then upload it using the Custom Tick Manager. The Tickmark add-in even has the ability to create a Ribbon icon that looks exactly like your custom creations!

Tickmark symbols

Feature Video

If you are curious about how this feature works, the below video walks you through a couple of different methods to create and store your very own custom tickmark icons with the Tickmark Add-in

Tickmark Excel Add-in: Creating Custom Ticks
Organize Ugly Spreadsheet Models

When you first get handed another person's spreadsheet model, one of the most overwhelming parts can be understanding the setup of the overall model.

Data Organizer

With the Tickmark Add-in's Data Organizer button you can easily decipher whether the data on a spreadsheet falls into one of the following categories:

  • Hardcoded Number

  • Formula

  • Off-Sheet Referencing Formula

  • Formula with a Plug

Take a look at how running the Data Organizer can quickly turn plain data into being meaningfully formatted. The Data Organizer can be run on an entire spreadsheet or just on an area of selected cells.

Data Organizer for Excel, before and after

As you can see from above, after running the Data Organizer you can immediately tell what numbers are being input into the spreadsheet and where the formulas are located. The Data Organizer even caught a formula for Widget 7 within the spreadsheet that had a +20 added to it that you may want to look into.

The Data Organizer's applied formats are not limited and you can go into the Tickmark settings and change any of the fill or font colors to match your formatting preferences.

You can even click a button to insert a pre-built legend so you can easily inform users or remind yourself what each format represents.

Customize formats for data organizer in Excel
Tickmark Excel Add-in: Investigate Buttons

Insert Hyperlinked Contents Tab (with “Back” buttons)

Another pain point that can arise while getting to know a spreadsheet model is navigating the sheer size of the model itself! How many times have you been given an Excel file to update and there are over 50 tabs to try and decipher? The Tickmark add-in allows you to insert a Table of Contents tab with hyperlinks to each one of the spreadsheet tabs in your workbook. You can choose to order the links Alphabetically or in the tab order. You can also add "Back" buttons to each tab so you can easily flip back and forth between all the spreadsheets.

Add back buttons to all spreadsheets to go back to table of contents.

Insert Instructions Tab

Let’s face it, one of the most undervalued tabs in a spreadsheet is the Instructions Tabs. It’s unfortunately far too many people forgo documenting how to use/update the spreadsheets they create. Tickmark attempts to make this step in the creation process a bit easier by allowing you to click a button and instantly create an Instructions tab that is ready for you to fill out.

Inserted is a tab at the beginning of your workbook named “Instructions” that has a textbox pre-created with bullets so you can begin to type away those vital instructions so you don’t have to worry about taking vacation days while your teammate updates your files!

Insert the instructions tab with into your Excel workbook.

Find Plug in formulas

Find Plugs In Formulas

Adding a plug can be common practice if you need your number to visually foot or if you have a one-off reason to modify a calculation.  There are typically two ways to make such adjustments (1) add the plug off to the side of your analysis and modify your formula to point to the "Plug Cell" or (2) just add the number directly into the formula itself.  

Plugs directly inside formulas can be detrimental because they can be easily forgotten about, they are not visible, and are oftentimes not documented as to their reason for being there.

Plug finder before and after spreadsheet

After running the Plug Finder on a spreadsheet tab, you instantly get a list of cells containing plugged numbers within formulas. These cells are also marked with a marker of your choosing (dot, circle, or box) in order to bring attention to the cells that were possibly tampered with. The markers are all shape objects, so they will not affect any formatting on your spreadsheets.

Excel Plug Finder settings window
Tickmark Excel Add-in: Investigate Buttons
Investigate Spreadsheets further.
Unhide all sheets

Unhide All Sheets

Tired of individually unhiding each tab hidden in your Excel file? With the Tickmark add-in, you can unhide all worksheets in your Workbook (including Very Hidden worksheets) with one click of a button!

Outside References

Lists all the outside sheets that are being fed into the current worksheet's formulas. This instantly gives you visibility into what tabs are feeding into your current worksheet.

The listing includes Internal sheets inside your workbook and External files referenced.

Outside references
Formula Auditing

Formula Auditing

The almighty Formula Auditing tools found in Excel's Formulas tab has been replicated so you have quick access to these powerful functionalities within the Tickmark Add-in.

Highlight important areas

Insert An Arrow Shape To Point Things Out

Draw and insert arrows based on the currently selected range of cells. You have the ability to determine the direction and length of the arrow based on how you select your cells. You can also go into the Tickmark Add-in settings and determine the default line color and line thickness for your arrows. Take a look at how various cell selections determine how the arrow looks!

Insert arrow in spreadsheets

Highlight Important Info with Boxes & Circles

Places a box or circle around your currently selected range of cells. This is a great way to bring attention to specific parts of your data that need attention. Through the Tickmark Settings, you can even determine the default border color and thickness to make your boxes and circles align with your preferences.

Highlight important info with boxes and circles inside Excel spreadsheets.

Create Comment Bubbles That Actually Stand Out

Add a comment bubble shape on top of the ActiveCell. You determine the direction of the spike. You can also go into the Tickmark settings and set your own default color formats and shape size!

Add a comment bubble to you excel sheet.
Custom formatting settings

The Tickmark add-in comes with lots of formatting and functionality settings allowing you to completely customize the add-in to your preferences.

Tickmark setting options.
Even more features

Spreadsheet Legends

Create a legend where you can inform your users (or remind yourself) of the meaning behind your color schemes. Select multiple cells to create more than one at a time.

Spreadsheet legends
Scroll to top of every tab in a worksheet

Scroll To The Top Of Every Tab

This button goes through every worksheet and scrolls to cell A1 (Top, Left). This is a great feature to run before sending your model off to someone or when you first open up a model to ensure you are starting off at the very top of every spreadsheet you dig into.

Seamlessly create hyperlinks between your Tickmark icons to navigate complex models or create Audit Trails.

Link your spreadsheet tick icons

Wait…There’s More!

  • Convert selected cells to numerical values (great for vlookups & xlookups!)

  • Convert selected cells to text (great for vlookups & xlookups!)

  • Swap two selected cell ranges with each other

  • Add outline groupings to all hidden rows or columns

  • Collapse/Expand all outline groupings (for selected sheet or entire workbook!)

  • Remove all outline groupings (for selected sheet or entire workbook!)

  • Unhide all hidden rows/columns/both (for selected sheet or entire workbook!)

Not sure, how about a test run?

A Free 14-Day Trial Just For You

I personally couldn't live without this add-in but I can understand if you think you may not use it. That is why I am willing to provide you with a trial version of this add-in so you can try it completely free for 2 weeks. I don't lock down any of the features, so you have complete access to every functionality! Download the Free 14-Day Trial Here.

TheSpreadsheet Guru Guarantee

Free Future Updates

As with all purchased products sold by TheSpreadsheetGuru, you don't have to worry about purchasing too early! After you purchase this add-in, you will be placed on an exclusive updates email list where you will directly receive any update made to this product.

30-Day Money-Back Guarantee

I'm so confident you will love this add-in, I'm willing to give you 30 days from your purchase date to decide if this is the tool for you. If you come to the conclusion that this add-in was not what you were expecting, just shoot me an email and I'll refund you your money back.  

So what's there to lose? Now is your opportunity to pick up this revolutionary add-in that will change the way you interact with your spreadsheets. Click the Buy Now button below to quickly get your hands on this amazingly powerful Excel add-in!

No Monthly Subscription Fees

Once you purchase this add-in you will never have to pay anything further. There are no hidden fees or monthly charges.

Add-in Licensing

Each license purchased (ie add-in unit) of this product is licensed for use by 1 user. This single user may activate this product on up to three of his/her computing devices to account for future equipment refreshes or working at home. If users are found attempting to share licenses, we reserve the right to terminate add-in functionality immediately.

Companies may choose to purchase multiple licenses (add-in units) in a single order. Once the license codes are distributed and activated, they will be tied to the respective users. Companies may contact TheSpreadsheetGuru via email in order to transfer licenses in the event an employee leaves the company or no longer needs the product's functionality. Feel free to contact us if you have any questions/concerns surrounding the licensing process.

Bulk Discounts For Your Organization

Buy Tickmark for your whole team or department and save! The discounted price will be applied automatically during your checkout process.

  • 5-9 units per single order --> 10% off the total cost

  • 10+ units per single order --> 15% off the total cost

What Are You Waiting For?!

Stop struggling to understand huge and complicated Excel Models and use the Tickmark Add-in to help create order in your spreadsheets. Tickmark is not just an add-in for auditors but a tool every analyst can use to ensure his or her models are accurate and can easily be understood by others. Pick up a copy of the Tickmark Add-in today!

TickmarkAddin DownloadTrial 1
BuyNowButton 147@2x 1