How to Find and Fix Circular References in Excel

A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s been entered) for the calculation. If this statement seems a bit confusing, don’t worry by the end of this tutorial it will start to make sense.In simple terms, a circular reference happens when a formula references … [Read more...]

Excel Flash Fill – How To Use

What is Excel Flash Fill, and more importantly, what is so special about it?Flash Fill is a special tool in Excel that can automatically fill in values for you once it recognizes a pattern in the data.Have you ever wondered if Machine Learning exists in Excel? And if it does, where does it exist? Flash Fill is one of those tools that use … [Read more...]

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...]