This tutorial explains the three different ways to change the font color in Excel VBA. VBA has many commands and functions that can be used. Using VBA we can easily do anything in Excel. VBA in Excel is an easy and fun thing to do. With VBA, you can change the color of the cell, …
3 Quick Ways to Change the Font Color in Excel VBA Read More »
The purpose of this blog post is to teach you how to lock / protect formula part only in Excel Dataset. Protecting or locking formula parts is one of the most important skills to learn in Excel. Excel datasets require a lot of effort to design formulas. And when we share the Excel file with a colleague, there may be a high chance that the formula will be changed or edited. Which could be harmful to you. To avoid this, we will present in this tutorial how to lock / protect formula parts only instead of the entire worksheet. What Is Protection …
How to Lock / Protect Formula Part Only In Excel (A Detailed Guide) Read More »
This blog post shows you that how to split cells diagonally in Excel. This situation comes when creating reports or dashboards with data in Excel and the need to split cells diagonally. Split Cells Diagonally The purpose of split cells diagonally is to add two heading in a single cell – one for rows and …
How to Split Cells Diagonally in Excel (Step by Step Guide) Read More »
This post is all about multiple ways to Remove Formulas and Keep the Values as it is.
In this tutorial, you will learn about visible cells and how to copy and paste the visible cells only in Excel. So for that, you need to know our dataset as shown in the below image. Here we have twelve-month data from January to December of all four zones (I, II, III, and IV). And …
3 Easy Ways to Select the Visible Cells Only In Excel Read More »
In this tutorial, you will learn to highlight every other row (or 2nd,3rd, or even nth) or column in Excel. Here we will use the below dataset with the evergreen feature “Conditional Formatting” of Excel. See the image below:- Highlight Every Other Row in Excel First of all, select the whole dataset where you want …
How to Highlight Every Other Row or Column in Excel Read More »
In this tutorial, you will learn about ‘How to Insert Blank Rows’ after every 2nd or 3rd or even after every nth row of the dataset. Here we are going to use the below-given dataset to insert the blank rows. See the dataset image below:- Insert Blank Rows After Every Next Rows To insert a …
How to Insert Blank Rows after Every (2nd or 3rd or nth) Row in Excel Read More »
In this tutorial, you will learn about Excel SUMIFS Function. This is an inbuilt function of Microsoft Excel and introduced in Excel 2007 and available after all the versions. This function can find the value within a dataset with single or multiple criteria or conditions. We have completed, Excel SUM and SUMIF Functions in our …
How to use Excel SUMIFS Function – With Multiple Example Read More »
Here we are going to learn about Excel SUMIF Function. This is a combination of Excel SUM and IF function. An introduction SUM function sums the values in a range where the IF function supply the criteria or condition for the same. More we will learn in this tutorial further. Use of Excel SUMIF Function …
How to use Excel SUMIF Function – Multiple Condition (with examples) Read More »
Blank Rows in Excel are common in any dataset, but not a good sign when calculating the dataset. Here you will learn about the 5 easiest methods to “Delete Blank Rows” in Excel.