Excel checkboxes: how to create a checklist

How to add a checkbox in Excel? How to tick a box? And where is the developer table? We answer it all in this article!

To create a checklist in Excel you may want to insert multiple checkboxes: learn how to add tick boxes with this quick tutorial.

Before showing you how to create a checkbox in Excel, let us indicate you where to find the checkbox tool. The easiest way to insert a tick box in Excel is to do it via the Developer tab.

In Microsoft Excel, add the developer tab by following these quick steps:

  • Click Microsoft Excel > Preferences.
  • Click View.
  • Select Developer tab under In Ribbon, Show.

Now that you know how to enable the Developer tab in Excel, let create a checklist together!

To insert a tick mark box in Excel, go to the Developer tab and click Checkbox.

After clicking Checkbox, click on your Excel worksheet: a check box is now created! Now, let customise it.

Check box.

We recommend deleting its name so only the tick box is visible. To do so, click directly on its name or change its name on the top left corner (next to formula).

Now drag the checkbox to the cell you want. In our example, we want to create a checklist and tick boxes when a gift has been sent to our most loyal customers.

Inserting a checkbox in Excel is quite simple and quick but if you need multiple checkboxes in your Excel table, this might take a while… Save time by copy-pasting the checkbox you just created by performing a drag and drop with a right click, as many times as needed.

You can also select multiple checkboxes and copy-paste several at a time.

Now that you have all the tick boxes created for your checklist, how to align them?

To align checkboxes in Excel, follow these 4 quick steps:

  • Select all your checkboxes;
  • Click Shape Format;
  • Click Align;
  • Select the alignment you want.

We could stop here and just tick boxes if a gift has been sent to each specific customer. Because it can be difficult to differentiate ticked and unticked boxes in Excel, when you have a lot of data, we recommend to spend a few more minutes customising the checklist.

To link a cell to a tick mark box, perform a right click on the box and select Format control. Then enter a value for cell link.

In our example, we want to link the tick box with cells in column F. For the checkbox in cell F3, the cell to link will be F3; for the one in cell F4, the cell to link will be F4, etc.

We could stop here as TRUE will appear when a box is ticked and FALSE when it isn’t.

We want to customise our table so text only appears when a box is ticked. To do so we use the IF function; here are the steps to follow:

  • Select the cells where TRUE/FALSE messages appear and change the text colour to white. Now we can’t see the text when we tick or untick a check box.
  • Enter =IF(F2=TRUE,”Yes”,””) in the G2 cell (it could be any cell but in our example we want to use this one).
  • Apply the same formula to other rows and enjoy your new clear checklist!

Now, you know how to create checkboxes in Excel and how to customise a checklist.

Join our online MS Excel Course and become a Spreadsheets Master!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More