How to count cells by font color in Excel

How to count cells by font color in Excel

Although Excel doesn’t have a built-in feature for counting cells based on their font colors, filtering results by their font color is possible. In this guide, we’re going to show you how to count cells by font color in Excel. Download Workbook Steps Right-click...
How to count colored cells in Excel

How to count colored cells in Excel

Although Excel doesn’t have a built-in feature to count cells by their colors, filtering cells by their color is possible. In this guide, we’re going to show you how to count colored cells in Excel. Download Workbook Steps Right-click on a colored cell in the...
How to refer a range or a cell in Excel VBA

How to refer a range or a cell in Excel VBA

In this guide, we're going to show you how to refer a range or a cell in Excel VBA. VBA Basics Before diving into the code, let’s start with a cell or a range means in VBA. First, VBA is an object-based programming language, which means that the language refers each...
How to format numbers as file sizes in Excel

How to format numbers as file sizes in Excel

Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...
How to populate alphabet letters in Excel in 3 ways

How to populate alphabet letters in Excel in 3 ways

You can populate numbers, names of months or weekdays easily by dragging your mouse. However, you can’t populate letters in the same fashion. In this guide, we’re going to show you how to populate Alphabet letters in Excel using three different methods....
How to remove all rows containing specific value in Excel

How to remove all rows containing specific value in Excel

In this guide, we’re going to show you how to remove all rows containing specific value in Excel. We are going to be taking a look at two methods: Find and Replace Filter These methods are good for removing all rows containing a specific value, such as repeating...
Function: NORMSINV

Function: NORMSINV

NORMSINV Excel formula is a Statistical function that calculates the inverse of the standard normal cumulative distribution of a specific probability. The standard normal distribution is a type of normal distribution with a mean of zero (0) and a standard deviation of...