Excel VBA: Advanced Filter with Multiple Criteria in a Range

 VBA Advanced Filter Syntax:  AdvancedFilter: refers to a range object. You can set the range where you want to apply the Filter. Action: ...

How to Divide a Group of Cells by a Number in Excel (3 Methods)

While performing some calculations in Microsoft Excel, we need to divide a group of cells by a number. We can divide a cell or the group of cells ...

Excel VBA: Form Control Checkbox Value – 3 Examples

The dataset showcases a course registration form with 6 different courses. Using a Code in the Visual Basic Editor Go to the Developer ...

How to Convert Number to Text and Keep Trailing Zeros in Excel

We have an Excel worksheet that contains information about different fruits and their price. We will use this worksheet to show how to convert number ...

How to Convert Number to Text for VLOOKUP in Excel (2 Ways)

Problems with the Text and Number Formats in VLOOKUP If your lookup value and the column values are in a different format, it will cause an error. ...

[Fixed!] Spell Check Is Not Working in Excel (4 Solutions)

To explore the fixes, we’ll use the following dataset that represents some clothes’ prices. Reason 1 - Excel Can't Check Spell in a Cell ...

How to Fix “Fixed Objects Will Move” in Excel (4 Solutions)

Solution 1 - Save Excel Files as XLSX or XLS Files to Fix “Fixed Objects Will Move” Error Follow these steps: Go to the File tab. ...

How to Use Variable Row Number as Cell Reference in Excel

As shown in the below screenshot, we want the sum of a couple of numbers. We can simply get the sum by summing the range (i.e., B5:B11). However, if ...

How to Combine Two Bar Graphs in Excel (5 Ways)

For a company, we have some Selling Prices and Profits for different years, which we have represented in two different bar graphs. Using the ...

How to Copy Conditional Formatting to Another Workbook in Excel

Conditional Formatting is one of the most used Excel tools. Conditional Formatting allows us to format cells according to our criteria. In this ...

Compare Two Columns in Excel and Highlight the Greater Value (4 Methods)

The sample dataset contains information about the sales amount of some salespeople for two months. We will compare the sales of the first month with ...

How to Delete Rows Based on Another List in Excel: 5 Methods

Method 1 - Delete Rows Based on Another List by Applying the Excel COUNTIF Function and Sort Option Steps: Type the below formula in Cell D5 ...

How to Add a Checkbox in Excel (2 Steps + 4 Uses)

Most likely you see a checkbox that is mainly used for selecting or deselecting any option. Though the process of adding a checkbox in Excel is quite ...

Calculate Years and Months between Two Dates in Excel

To calculate years and months between two dates we are going to use this dataset. It contains some start dates and end dates, and we'll get the ...

How to Make Cells Independent in Excel (5 Methods)

The dataset below shows information about some people in a charity organization, including their names, ages, contributions per month, and ID ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo