How to Select Multiple Cells in Excel Without Mouse (9 Easy Methods)

In this article, I will discuss how you can select multiple Excel cells without using a mouse. I will use keyboard shortcuts mostly to select cells. ...

Excel Find Last Occurrence of Character in String (8 Methods)

Our sample dataset has three columns: Company Name, Employee Code, and Last Occurrence. Employee Code contains the name, age, and department of an ...

How to Find the First Value Greater Than in Excel (4 Methods)

Dataset Overview We have a dataset with columns for State Name (Column B), Budget Allocation (Column C), and Region (Column D). We'll identify the ...

How to Use Dynamic Range for Last Row with VBA in Excel (3 Methods)

Why Do You Need a Dynamic Range We have a simple dataset with Quantity, Unit Price, and Sales of some Items. We want to find the average, sum, ...

Create Dynamic Named Range with VBA in Excel (Step-by-Step Guideline)

We can refer to a certain range of cells in the Excel worksheet by using the Define Name feature. But, we constantly need to add new data or update ...

Dynamic Sum Range Based on Cell Value in Excel: 4 Ways to Create

Method 1 - Use INDEX Function to Create Dynamic Sum Range Based on Cell Value in Excel We will use a dataset that contains information about the ...

How to Combine Two Scatter Plots in Excel (Step by Step Analysis)

In Excel, the combination of scatter plots allows you to show and analyze two separate data sets that are connected to each other. A standard chart ...

How to Remove Duplicates from a Drop Down List in Excel (4 Methods)

Dataset Overview Let’s assume you have a large Excel worksheet containing information about various fruits and vegetables imported by a country into ...

How to Remove Used Items from Drop Down List in Excel (2 Methods)

While working with data validation in Excel, you might need to remove used items from the drop-down list to avoid assigning an item in the list ...

How to Apply Multiple Data Validation in One Cell in Excel: 3 Methods

Method 1 - Apply Multiple Data Validation in One Cell in Excel with Specific Criteria STEPS: Combine the criteria formulas in a nested formula ...

Excel VBA to Find and Replace Text in a Column: 2 Methods

Method 1 - Use the Replace Method of VBA to Find and Replace Text in a Column A. Build the Code Open VBA Editor Press Alt+F11 on your ...

How to Set Due Date Reminder in Excel (3 Quick Methods)

We’ll use the following dataset that represents some buyers’ invoice amounts and due dates. Method 1 - Combine TODAY, AND, and IF ...

Multiple Excel Cells Are Selected with One Click: 4 Causes+Solutions

Method 1 - Disable the Extend Selection Mode If Multiple Cells Are Selected with One Click Look at the following screenshot. Only cell B5 is ...

How to Convert Date to Day in Excel (7 Quick Ways)

The sample dataset contains Festival’s Name and Date. We will convert the Date to Day. Method 1 - Adopting Format Cells Feature to ...

How to Find and Replace Blank Cells in Excel (4 Methods)

The sample dataset contains student's names along with their Student ID and their Marks. Some students did not take the exam and so their mark is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo