ExcelDemy - Page 84 of 240 - Free Excel Tutorial & Online Courses

[Fixed!] Relative Cell Reference Not Working in Excel

May 25, 2022 Excel Formulas 1

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)

Mar 28, 2022 Macros & Excel VBA

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)

Mar 27, 2022 Excel Basics

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

Mar 13, 2022 Excel Basics

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)

Mar 27, 2022 Excel Basics

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)

Mar 23, 2022 Macros & Excel VBA

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)

May 25, 2022 Excel Basics

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)

Mar 15, 2022 Excel Formulas

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)

Mar 13, 2022 Excel Basics

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)

Apr 13, 2022 Excel Basics

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

May 25, 2022 Excel Formulas

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

Mar 14, 2022 Macros & Excel VBA 1

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

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

Mar 13, 2022 Macros & Excel VBA

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 ...

Latest Posts