How to Filter and Delete Rows with VBA in Excel – 2 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company. Method 1 - Filtering the Visible Rows and Deleting them with ...

How to Concatenate Rows in Excel (11 Methods)

Concatenate means to merge or combine two or more cells’ contents into a single cell. Method 1 - Applying Ampersand(&) Operator to ...

How to Disable Copy and Paste in Excel without Macros (With 2 Criteria)

Sometimes we need to share our Excel worksheet with users or clients. Suppose we want them to only be able to view the worksheet but not copy and ...

Excel VBA to Count Duplicates in a Column (A Complete Analysis)

While working with VBA in Excel, we often need to count duplicates in a column in a worksheet. In this article, I’ll show you how you can count ...

How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)

In this article, you will get to know about various ways to create a formula in Excel that will place the word Yes easily. Sometimes we want a result ...

How to Count Non-Blank Cells with Condition in Excel (6 Methods)

The dataset contains information about several students: student names, IDs, and marks secured in Physics and Chemistry. Method 1 – ...

How to Calculate Remaining Days in Excel (5 Methods)

We have an Excel file that contains information on the Start Date and End Date of different projects. We will use this worksheet to calculate the ...

How to Delete Selected Rows with Excel VBA (Step-by-Step Guide)

This article shows how to delete selected rows in Excel with VBA in the simplest possible way. Surely you can add or delete rows or columns manually ...

How to Count Duplicates in Two Columns in Excel (8 Methods)

Column B depicts the List of US Companies by Revenue (List-1) while column D shows the List of US Companies by Profit (List-2). We’ll count the ...

How to Create a Day Countdown in Excel (2 Examples)

Example 1 - Use the TODAY Function to Create a Day Countdown in Excel Here is a common template of the TODAY formula. We’re going to make a ...

Excel VBA to Copy and Rename a Worksheet Multiple Times

Below is a sample sheet named “Dataset” which we will use to illustrate how to duplicate a sheet multiple times and rename it in Excel using VBA. ...

Excel VBA to Copy Formula with Relative Reference (A Detailed Analysis)

While working with VBA in Excel, we often need to copy formula (s) with relative cell reference (s) from one range to another range. In this article, ...

How to Calculate Gross Profit Margin Percentage with Formula in Excel: 2 Methods

Method 1 - Excel Formula to Calculate Gross Profit Margin STEPS: Select the cell where you want to get the gross profit margin. Select cell E5. ...

Excel INDEX MATCH to Concatenate Multiple Results (With 2 Easy Steps)

While working in Microsoft Excel we might need to concatenate different multiple results from a particular dataset. In this article, we will ...

How to Copy Excluding Hidden Rows in Excel – 4 Easy Methods

This is the sample dataset. Method 1. Applying a Keyboard Shortcut to Copy Rows in Excel (Except Hidden Ones) Some rows are hidden in this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo