Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Checkbox
Have you ever wondered how to set up checkboxes in Excel that check themselves automatically based on the value of another cell? Whether you’re tracking tasks, orders, or reviews, Excel’s checkbox feature can streamline your process. In this blog post, we’ll walk through step-by-step examples to create self-checking checkboxes. Let’s dive in! Video Step-by-step Tutorial…
Read More
Today, I’ll tackle a question I received recently about checkboxes. The question was essentially about how to add two values in Excel when a checkbox is checked. I’ll walk though the answer with you in this short post. Let’s jump right in! Video Step-by-Step Guide Exercise 1: Getting Started with Checkboxes To get started, we…
Read More
Welcome to this tutorial on how to find invalid characters in Microsoft Excel. In this tutorial, we will explore different methods including formulas and conditional formatting to detect and highlight characters you define as “invalid” in your Excel worksheets. Since you can easily customize the list of “invalid” characters, this approach is extremely flexible and…
Read More
The goal of this tutorial is to learn how to insert checkboxes in Microsoft Excel using two different methods: checkbox cell controls and legacy form controls. We will also explore how to use checkboxes in formulas, conditional formatting, and how to activate the developer tab for legacy form controls. Video Step-by-step Exercise 1: Inserting Checkboxes…
Read More