How to Unlock Cells without Password in Excel (4 Methods) 

This article illustrates how to unlock cells in Excel without a password with 4 different methods. Excel allows the feature to lock cells with ...

How to Skip Blank Rows Using a Formula in Excel – 8 Methods

The sample dataset contains blank rows. Method 1 - Using Keyboard Shortcuts to Skip Blank Rows in Excel Step 1: Select B5:F14, and ...

Using Excel VBA to Count Blank Cells in a Range – 3 Methods

This dataset contains blank cells.   Method 1 - Embed a VBA to Count Blank Cells in a Range with the COUNTIF Function Steps: ...

VBA to Copy Data to Another Sheet with Advanced Filter in Excel: 3 Methods

Method 1 - Embed VBA Code to Copy Data to Another Sheet with Advanced Filter in Excel Steps: Press Alt + F11 on your keyboard or go to the tab ...

How to Combine Graphs with Different X Axis in Excel

How to Create Graphs in Excel This is a sample dataset:   Steps Select B4:C11. The Quick Analysis option will be displayed at ...

Excel VBA: Delete Files with Wildcards (4 Methods)

VBA allows us to delete any file on the computer by utilizing VBA programs. Using simple VBA programs, we may delete any individual file, specified ...

How to Find Blank Cells Using VBA in Excel: 6 Methods

Method 1 - Check Whether a Specific Cell Is Blank or Not Step 1: Open Microsoft Visual Basic; insert a Module using the instruction section. Paste ...

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

Let's consider a scenario where a car dealer gives its cars code with this format: Car Model-Year. We have taken a dataset consisting of Car Model, ...

Excel Formula to Compare Two Cells in Different Sheets: 4 Methods

Method 1 - Applying Excel Formula to Compare Two Cells in Different Sheets Enter the following formula in cell D5 in Sheet1. Then use the fill ...

How to Use Excel VBA to Convert a Number to Text (4 Examples)

The dataset below represents the published article numbers of some writers on a content publishing site named ExcelDemy. The numbers are in number ...

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

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in ...

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

  What Is a Prompt Warning Message? The following VBA code creates a new Excel worksheet and deletes it when you run the code. Sub ...

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

We have the Product List and the Order List of the products of a company, and we want to check if the products of the Order List are available in the ...

Excel VBA: Insert Formula with Relative Reference (3 Ways)

In this article, we'll discuss how to use Excel VBA to insert a formula with relative cell references in a single cell or a range of cells. ...

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

In this article, we will learn how to Turn on Spell Check in Excel using the Review tab, shortcut key, and VBA code. But, let's first learn how to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo