How to Delete Rows in Excel with Specific Text: 3 Ways

Method 1 - Using the Find Feature to Delete Rows with Specific Text Delete all the rows matched with the text "Alan." We'll show deletion for both ...

How to Create a Quarterly Compound Interest Calculator in Excel

Understanding Compound Interest Compound interest allows you to earn interest on both the initial investment (the principal) and any previously ...

How to Copy Rows Automatically in Excel to Another Sheet (4 Methods)

Method 1 - Automatically Copy Rows in Excel to Another Sheet Using Filters In the following dataset, we will copy all rows from the data range ...

On Error Resume Next: Handling Error in Excel VBA

Method 1 - On Error Resume Next’ Statement to Hide Worksheets in Excel VBA This is a VBA code that will hide all the worksheets of your active ...

Errors in Excel and Their Meaning (15 Different Errors)

We're going to use a sample dataset to show most common errors. The following dataset represents the Salesman, Product, and Net Sales of a company. ...

Excel VBA: Delete Sheet If It Exists (4 Methods)

In this article, we’ll illustrate how to delete a sheet if it exists from a workbook using VBA in Excel with 4 examples. As deleting worksheets is a ...

How to Delete a Row Using Macro If a Cell Contains 0 in Excel (4 Methods)

The dataset below shows the Number of Visits, the Names of the Sites, and the Dates. Some sites have a cell value (Number of Visits) of 0. In such a ...

How to Copy Formula to Another Sheet in Excel (4 Methods)

  Method 1 - Apply Keyboard Shortcuts to Copy a Formula to Another sheet in Excel   Steps: Press Ctrl+C to copy a selected ...

How to Count Filled Cells in Excel Using VBA: 7 Methods

Method 1 - Use VBA Macro to Count Filled Cells from a Range Step 1: Open Microsoft Visual Basic, insert a Module using the instruction section. ...

Calculate Number of Days Between Two Dates with VBA in Excel

While working with dates with VBA in Excel, we often have to calculate the number of days between two dates. In this article, I’ll show you how you ...

Excel Error: The Number in This Cell is Formatted as Text (6 Fixes)

How to Find a Cell That is Formatted as Text or Preceded by an Apostrophe When we use an apostrophe before a number, or when values are stored ...

How to Copy Worksheet to Another Workbook Using VBA

For illustration, we have a sample workbook named "Source" with three worksheets "List-1", "List-2", and "List-3". We will copy these ...

[Solved!] Can’t Delete Extra Columns in Excel: 3 Reasons and Solutions

To show the reasons and solutions, we’ll use the following dataset that represents some salespersons’ sales in different regions. Method 1 ...

How to Delete Column and Shift Left Using VBA in Excel (5 Methods)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete those unnecessary data in ...

How to Delete Unfiltered Rows in Excel Using VBA (4 Ways)

Sometimes, when while working with a dataset we want to filter data and only want the visible cells and delete unfiltered rows in Excel. In this ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo