Latest Blog Posts

How to Count Specific Characters in a Column in Excel – 4 Methods

The sample dataset showcases authors and book titles: Method 1 - Using the SUMPRODUCT Function to Count Specific Characters in a Column ...

How to Insert Pictures Automatically Size to Fit Cells in Excel: 3 Methods

For the purpose of demonstration, I have used the following sample dataset. Here, the dataset contains information about Microsoft Office products. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo