How to Delete a Column in Excel Without Affecting the Formula – 2 Methods

The following dataset showcases Unit Production in column C and Per unit Cost in column D. The total per month is calculated in column E. To ...

How to Count Number of Characters in a Cell in Excel?

If you are looking for some of the easiest ways to count the number of characters in a cell in Excel, then you are in the right place. Sometimes it ...

How to Delete Rows in Excel: 7 Methods

This article will show seven effective techniques to delete rows in Excel, with examples and illustrations. Download the Practice Workbook In ...

How to Delete Blank Cells and Shift Data Up in Excel: 8 Methods

Method 1 - Deleting Blank Cells Manually Steps: Hover the cursor until a downward pointing arrow appears >> left-click to select the ...

How to Create a Range of Numbers in Excel (3 Easy Methods)

Method 1 - Use the Data Validation Option to Create a Range of Numbers in Excel In this datasheet, we have used 3 columns and 7 rows to represent ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo