How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can be quite helpful while designing forms in Excel.These controls prevent users from entering some unwanted data in your forms, and hence they are preferred.In this post, we will … [Read more...]

How to Insert Multiple Rows in Excel

In the last few decades, Microsoft has grown by leaps and bounds and so are its fabulous products. Microsoft Excel is one such product that has grown immensely. It has wonderful features and options to make your tasks easier. But one feature that it lacks is the ability to insert multiple rows. The default insert option that Excel has allows you to … [Read more...]

How to Spell Check In Excel

Microsoft Excel doesn't have advanced capabilities like grammar checking and correction but still, it offers the basic spell checking functionality. This built-in spell checker in Microsoft Excel can help you to double-check your excel sheets before you send them across to someone else.One thing that I would like to point out is that the … [Read more...]

Counting Unique Values In Excel – 5 Effective Ways

Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each value.Though this can be a very common requirement in many scenarios but excel doesn’t have any single formula that can directly help us to count unique values in excel inside a range.In today’s post, we will see 5 … [Read more...]

Sum Cells based on Background Color

Few weeks back, one of my regular visitors dropped me an email describing an issue that he was facing. His task was to add the contents of certain cells based on their background colors.As we all know, Excel by default has no formula or feature to calculate such a thing. So, in this post I will share few methods that will help you to achieve … [Read more...]

How to Find External Links or References in Excel

Manually finding external links or references in a spreadsheet is a cumbersome task.  Microsoft does not have any inbuilt function that can find external references or links but still there do exist some workarounds to do this. And this is what I am going to share with you today.Method 1: Finding external References by using the find … [Read more...]

Use an Image as a Background in Excel

Generally, most of us have seen Excel as a plain and monotonous piece of software.But have you ever thought about how you can use your creativity to create amazing and attractive spreadsheets?In this post, I am going to share one such technique, here we are going to learn how to add background images in your Excel worksheets.So grab a … [Read more...]

Extract Filenames from Filepath in Excel

Getting filenames from a Filepath looks like an easy task at first sight. But actually, this is a very cumbersome task when you are dealing with a large number of file paths. Very recently I also wanted to do this task and during the process of extracting filenames, I found few methods that can automate this process.And today I will be sharing … [Read more...]