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

How to Find Blank Cells Using VBA in Excel (6 Methods)

Mar 28, 2022 Macros & Excel VBA

In general, Excel workbooks contain numerous cells. And numerous cells are kept blank for multiple reasons. There are multiple ways to find blank ...

How to Combine Two Cells in Excel with a Dash (5 Methods)

Apr 18, 2022 Excel Formulas

In this article, we have shown 5 methods of how to combine two cells in Excel with a dash. Let's consider a scenario where a car dealer gives its ...

Excel Formula to Compare Two Cells in Different Sheets (3 Examples)

Apr 20, 2022 Excel Formulas

This article illustrates how to use excel formula to compare two cells in different sheets. Now and then, you might need to compare data in different ...

Excel VBA to Convert Number to Text (4 Examples)

Mar 30, 2022 Macros & Excel VBA

We can easily change the format of numbers to text using commands in Excel. But it’s not so feasible in all cases. In some particular cases, VBA can ...

How to Group Cells with Same Value in Excel (3 Methods)

Mar 16, 2022 Excel Basics

If you are working with data with different categories or have cells with the same value in your Excel worksheet, then you might need to group the ...

How to Delete a Worksheet with No Prompt Using Excel VBA (5 Methods)

Mar 27, 2022 Macros & Excel VBA

While deleting an Excel worksheet, it shows a prompt warning message. When you have only one worksheet to delete, you can easily manage a single ...

How to Check If Value Exists in Range in Excel (8 Ways)

May 25, 2022 Excel Basics

If you are looking for some of the easiest ways to check if a value exists in range in Excel, then you will find this article useful. For a large ...

Excel VBA: Insert Formula with Relative Reference (All Possible Ways)

Mar 17, 2022 Macros & Excel VBA

To insert one or more formula with relative cell reference is one of the most important and widely used features that we encounter everyday while ...

How to Turn on Spell Check in Excel (3 Ways)

May 23, 2022 Excel Basics

While working in Excel, Excel might not correct all the spelling mistakes but it offers some methods to automatically check spelling mistakes. We ...

How to Lock Multiple Cells in Excel (6 Suitable Methods)

May 25, 2022 Excel Basics

Basically, you may need to lock multiple cells for two reasons. One is to lock cells for protecting them from further edits or changes whereas the ...

How to Combine Two Line Graphs in Excel (3 Methods)

Mar 27, 2022 Advanced Excel

In this article, we will learn how to combine two line graphs in Excel. Generally, we need to combine two graphs in one graph paper to show our ...

Excel Checkbox: If Checked then Change Cell Color (2 Methods)

Apr 20, 2022 Excel Basics

In Microsoft Excel, using the checkbox or the tick box is not very common. But you will see this to solve a lot of problems. It basically creates a ...

How to Count Repeated Words in Excel (11 Methods)

Mar 16, 2022 Excel Formulas

In Microsoft Excel, we work with a large amount of data. In a large datasheet, usually, we see some repeated words. It is tiresome to find out those ...

How to AutoFill Sequential Letters in Excel (5 Quick Ways)

May 25, 2022 Excel Basics

It will be very supportive if we can AutoFill sequential letters in Excel instead of putting them one at a time. In this article, I will try to show ...

Excel VBA: Turn Off the “On Error Resume Next”

Mar 16, 2022 Macros & Excel VBA

One of the most important jobs in Microsoft Excel VBA is error handling. If you're a programmer, you're well aware of the necessity of error handling ...

Latest Posts