## How to remove Fill Color in Excel

Fill colour is a popular formatting feature in Excel that allows you to highlight cells with a specific colour. However, there may be times when you want to remove fill colour from cells. This could be because you want to change the colour or remove formatting altogether etc. In this tutorial, we will learn how … Read more

## How to remove excess rows from Excel

Here we have a small example dataset above about fruits and their prices. There are some excessive rows in this dataset, we will be removing these excessive rows by following the steps below, let’s first have a look at the dataset.

## How to Remove DIV/0 Errors in Excel

In this this tutorial we learn how to remove this error from Excel by following the steps below but first let’s have a look at an example dataset with #DIV/0! Error. This dataset above is related to school which contains student Marks of Different Subjects, Total Subjects and Average Marks.

## How to make a family tree in Excel

For our example, we’ll use a sample family tree for the Johnson family. The family tree will include the names, ages, and relationships of each family member. Here are some steps you can follow to create a basic family tree in MS Excel:

## How to use MATCH function in VBA in Microsoft Excel

In this tutorial, we will learn how to use the MATCH function in VBA in Microsoft Excel. Excel provides the built-in MATCH function however it may not always be sufficient for complex data sets or specific needs. This is where VBA can be particularly useful in Excel. With VBA we can automate the process to … Read more

## How to do cumulative sum in Excel

Cumulative sum in Excel is a mathematical operation that calculates the total sum of a series of values over time such as a sequence of months or years. It represents the sum of all the previous numbers in the series, including the current value. You can use the cumulative sum in Excel to analyse data … Read more

## How to insert multiple blank rows in Excel

While working in MS Excel sometimes inserting single or multiple rows is necessary. A few of the reasons are listed below: Adding new data: When working with Excel, it is common to have new data that needs to be added to an existing worksheet. By inserting rows, users can make space for new data without … Read more

## How to keep top row visible in Google Sheets

The top row freeze feature in Google Sheets allows you to keep the top row visible as you scroll down through your spreadsheet. This can be particularly helpful if you have a large dataset and need to keep the header row visible at all times, as it allows you to quickly reference the column headers … Read more

## How to delete thousands of rows in Excel

When you have a large Excel spreadsheet with many rows of data that you no longer need, you may want to delete them to reduce the file size and make it easier to work with. If you have thousands of rows to delete, you can use Excel’s built-in functionality to quickly remove them. This involves … Read more

## How to delete rows in Excel based on cell value

Deleting rows in Excel based on cell value means removing rows that contain a specific value in a particular cell.  This can be useful for filtering out unwanted data or cleaning up a spreadsheet with a large amount of data. The method involves using the filtering function in Excel to select only the rows with … Read more