Latest Blog Posts

How to Copy and Paste in Excel without Formulas (7 Easy Methods)

We have a dataset containing sales data along and total sales. We have used Excel functions to get the Total Sales. We will show you how to copy and ...

Drag Number Increase Not Working in Excel (A Solution with Easy Steps)

Sometimes the AutoFill feature in Excel does not work to autoincrement numbers when dragging through rows or columns. Here's an overview of the ...

How to Undo Delete Sheet in Excel – 3 Methods

  Method 1- Making a Copy of an Existing Sheet to Undo Delete Sheet in Excel Step 1: Click File. Click Save As. Save ...

How to Autofill Days of Week Based on Date in Excel (5 Easy Ways)

We'll use a sample dataset as an example. For instance, the following dataset represents a Salesman and his Joining Date in a company. We will ...

How to Delete Rows in Excel without Affecting Formulas?

Sometimes you need to delete rows in Excel but want to keep the formulas. In this article, we will discuss how to delete rows in Excel without ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo