How to Delete Multiple Rows in Excel with Condition?

While working in Excel, we sometimes have to delete multiple rows from a data set with a given condition. Today I’ll show you how to delete multiple ...

How to Remove Text After Character in Excel: 4 Easy Ways

Using Find & Replace Feature Select your data. Press Ctrl + H to get the Find and Replace dialog. Or, go to the Home tab > Editing ...

How to Delete Named Range in Excel (3 Methods)

To mention the results of the formula or cell references, we use the named range. It makes our formula easy and dynamic. We can easily remember the ...

How to Make a Table in Excel (2 Simple Ways)

In Excel, we need to make a table where we must arrange a data range in a structured form. So that we don’t need to format each cell every time. In ...

How to Delete Selected Rows in Excel?

Sometimes we need to remove some unwanted rows from the sheet in Excel. We can do it using the delete option. In this article, I’m going to explain ...

How to Delete Unused Columns in Excel (6 Methods)

  The sample dataset contains Product, Product Code, Color, Size, and Price columns and two unused columns as indicated in red to be deleted. ...

How to Delete Multiple Sheets in Excel (3 Ways)

In this tutorial, we will explore 3 ways to delete multiple sheets in Excel, and how to do so based on different criteria. To illustrate, we have ...

Why Excel Shows Formulas Instead of Results (7 Reasons)

For example, we have the following dataset and you see Excel is showing formulas in the cells instead of calculated results. Let’s check how we can ...

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

We have a dataset that contains some employees’ salaries for two years and their salary increments. Method 1 - Use the AutoFill Tool ...

How to Lock a Cell in Excel Formula (2 Easy Ways)

Method 1 - Assigning a Dollar Sign ($) Manually to Cell References Steps: Let’s calculate the speed of light for the Water medium. Select ...

Percentage Formula in Excel: 6 Ideal Methods

Method 1 - Calculate Percentage Using Basic Formula in Excel Example for Basic Percentage Formula in Excel: Assume that we have a simple data ...

How to Delete Every Other Row in Excel

Method 1 - Using Filter Feature to Delete Every Other Row in Excel Step 1: Select the column header. From your Home Tab, go to the Editing ...

How to Calculate Difference Between Two Dates and Times in Excel

  Part 1 - Calculating the Difference Between Two Dates in Excel We have the Starting Date of different projects in column C and the Ending ...

How to Reference to Another Sheet in Excel (5 Suitable Methods)

  Download Practice Workbook Download this practice sheet to exercise while you are reading this article. Referencing Another Sheet.xlsx ...

How to Auto Update Current Time in Excel (3 Easy Ways)

  Method 1 - Using the NOW Function  Steps: Select cell C4 and enter this formula: =NOW() Press Enter. It will enter ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo