Excel Tips and Tricks
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. [button...
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. [button...
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 fill blank cells simultaneously using Find & Select in Excel
In this guide, we're going to show you how to fill blank cells simultaneously in Excel. How to...
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. [button...
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. Introduction...
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...
How to create recursive functions in Excel with LAMBDA
Recursive function is a term for describing behavior of a function that calls itself from within its own code. This is necessary for solving a problem where the solution relies on the results from multiple instances of the same problem. In this guide, we're going to...
How to calculate the Ackermann function in Excel
The Ackermann function, named after Wilhelm Ackermann, is a multi-variable function from natural numbers to natural numbers with a very fast rate of growth. The function relies on solving with recursive calculations. In this guide, we're going to show you how to...