Latest Blog Posts

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

How to Lock Multiple Cells in Excel – 6 Methods

This is the sample dataset.   Method 1 - Using the Format Cells Option Step 1 - Removing the Default "Locked" Option  Place ...

How to Combine Two Line Graphs in Excel – 3 Methods

How to Combine Two Line Graphs in Excel This is the sample dataset. To show Alex and John's sales over the six months: Method 1 - Use ...

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

How to Insert Checkboxes in Excel Method 1 - Insert a Single Checkbox Steps Go to the Developer tab in the ribbon. If you don’t see the tab, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo