Latest Posts

How to Remove Empty Rows in Excel (11 Methods)

In a large worksheet, there remains a possibility of having empty rows. From this article, you will get to know how to remove empty rows in excel. ...

Convert Text to Date and Time in Excel (5 Methods)

In Excel, we mainly work with data. We organize and manipulate data as per our requirements. We find out the required information from our managed ...

Excel VBA Code to Delete Rows Based on Multiple Cell Value (3 Criteria)

In this article, I’ll show you the VBA code to delete rows in Excel based on multiple cell value. You’ll learn to delete rows when multiple cells ...

Excel Formula to Split One Column into Multiple Columns (4 Examples)

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and ...

How to Create and Use ColorFunction in Excel

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is ...

Excel SUMIF with a Date Range in Month & Year (4 Examples)

Working with date-based data is one of the most common uses of Microsoft Excel. We perform various calculations based on dates. We use various ...

How to Use SUMIFS with Date Range and Multiple Criteria (7 Quick Ways)

Working on Excel, you may often need to sum numbers within specific dates. This article will provide you with 7 quick methods to apply the SUMIFS ...

How to Calculate Years Between Two Dates in Excel (2 Methods)

It is quite a common incident to work with dates while working in Excel. Very often we may need to calculate dates or years between two given dates. ...

Excel Create Dynamic List from Table (3 Easy Ways)

In general, lists are made by extracting entries from a dataset. If the lists update automatically then the lists are dynamic lists. In this article, ...

How to Split String by Length in Excel (8 Ways)

If you are looking for some of the easiest ways to split string by length in Excel, then you are in the right place. So, let’s get started with this ...

Excel Formula to Get First 3 Characters from a Cell(6 Ways)

Sometimes when data is copied from another source then there is a possibility of having a couple of information compact together. For this type of ...

VBA to Transpose Array in Excel (3 Methods)

Implementing VBA is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to transpose ...

How to Delete Blank Rows in Excel (10 Methods)

Imagine a case when you have a set of data in an Excel worksheet, and you see some unnecessary blank rows. No doubt, such unexpected empty rows annoy ...

How to Rotate Text in Excel ( 3 Easy Techniques)

By default, Excel cells store horizontally aligned text. But for our purposes, very often we need to change the orientation of the text in cells from ...

How to Wrap Text in Excel (4 Easy Techniques)

When a text length is greater than a cell length, some part of the text becomes invisible due to the lack of enough space allocated for the text. To ...

ExcelDemy
Logo