How to Create a Tally Counter in Excel

You can build a simple tally counter inside Excel with no coding. It is useful when your counts need to live in a spreadsheet anyway. Here are two easy methods, plus when you are better off using a dedicated online counter instead.

Method 1: Counter With a Spin Button (No Macros)

1. Enable the Developer tab: File > Options > Customize Ribbon > check “Developer”.
2. Pick a cell for your count, for example B2, and type 0 in it.
3. On the Developer tab, click Insert > Spin Button (under Form Controls) and draw it next to B2.
4. Right-click the spin button, choose Format Control, and set: Current value 0, Minimum value 0, Maximum value 100000, Incremental change 1, Cell link $B$2.
5. Click the up arrow to count up and the down arrow to count down. Cell B2 is now a working tally counter.

Method 2: One-Click Counter With a Simple Macro

1. Press Alt + F11 to open the VBA editor, then Insert > Module.
2. Paste this tiny macro:
   Sub AddOne()
  Range("B2").Value = Range("B2").Value + 1
End Sub
3. Back in Excel, Developer tab > Insert > Button, draw it on the sheet, and assign the AddOne macro.
4. Every click on the button adds one to B2. Save the file as .xlsm (macro-enabled).

When an Online Counter Is the Better Choice

Excel works fine at a desk, but counting usually happens on your feet — at events, in warehouses, at the gym. An online counter on your phone is faster to open, has bigger tap targets, needs no setup, and can run many counters at once. Use Excel when the numbers must live in a report; use a tap counter when the counting itself is the job.

Frequently Asked Questions