Latest Posts

[Fixed!] Relative Cell Reference Not Working in Excel

In Microsoft Excel, using cell references in the formulas is the most common thing that you will do. It is a day-to-day operation for every Excel ...

Excel VBA: Delete Row If Cell Is Blank (A Complete Guide)

While working with VBA in Excel, we often need to delete a row if any cell is blank. In this article, I’ll show you how you can delete a row if a ...

How to Change Cell Size in Excel (5 Methods)

We always change cell size in Excel. There is more than one way to do this task. We have explained 5 methods of how to change cell size in Excel. To ...

Difference Between Paste and Paste Special in Excel

The Paste command in Excel is an operation command that inserts data from the clipboard that you’ve already stored by copying the data from somewhere ...

How to Reset Cell Size to Default in Excel (5 Easy Ways)

In this article, we will learn to reset cell size to default in Excel. A cell has a rectangular shape that has a width and a height. We can change ...

VBA to Delete Every Other Row in Excel (6 Criteria)

When we have a large amount of data with lots of unnecessary rows in our Excel worksheet, it is hard to understand sometimes. If we remove the rows ...

How to Add Text after Number with Custom Format in Excel (4 Ways)

If you are looking for some of the easiest ways to add text after number with custom format in Excel, then you are in the right place. So, let’s ...

Formula to Copy Cell Value and Format in Excel (5 Uses)

Sometimes while working in Excel we need to copy cells. But sometimes while copying the format of the cells may change which will make our task ...

How to Lock Cells in Excel Formula (2 Easy Ways)

We create many formulas involving different cells in our Excel worksheet. But, when we try to paste the formula somewhere else, the cells present ...

How to Create a Formula in Excel without Using a Function (6 Approaches)

Excel is one of the most useful tools we are familiar with. It enables us to perform myriads of calculations applying the functions available in ...

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel

While working with a large Microsoft Excel, sometimes we need to count cells with multiple criteria. In our Excel worksheet for the convenience of ...

Excel VBA: Get Cell Value from Another Workbook without Opening

If you are working with different Excel files that contain the same type of information i.e, information of the employees from different departments ...

How to Apply Conditional Formatting in Excel If Another Cell Is Blank

Perhaps you may have a larger dataset with numerous blank cells. Using a popular highlighting tool i.e. Conditional Formatting, you are easily able ...

How to Format Cell Based on Formula in Excel (13 Examples)

Sometimes we need to format cells according to our requirements in our Excel datasheet. But, formatting with the Format Cells feature takes some time ...

Excel VBA Codes to Bold Text in a String (5 Examples)

Changing font styles while working with Microsoft Excel is one of the familiar tasks. We perform this in Excel day-to-day. Changing the font style to ...

ExcelDemy
Logo