Excel Basics

Example of Mixed Cell Reference in Excel (3 Ideal Types)

Any Excel worksheet is made of numerous cells. These cells are referenced based on their row or column position for calculation. There are 3 types of ...

How to Name a Range in Excel (5 Easy Tricks)

In Microsoft Excel, there are several methods to name a range and make it also dynamic simultaneously. The named ranges are easy to prepare. They are ...

How to Delete Row If Cell Is Blank in Excel?

We have some rows with blank cells, and we'll delete entire rows that have blanks. Method 1 - Using the Go To Special Command Select ...

How to Select Every Other Row in Excel: 6 Easy Methods

The following dataset is about the sales information of a certain tech shop. It has four columns: Sales Rep, Region, Product, and Sales. These ...

How to Compare Three Columns Using VLOOKUP in Excel: 3 Methods

Method 1 - Inserting VLOOKUP with a Helper Column to Compare Three Columns in Excel Steps: Create a helper column. Go to E5 and insert the ...

Automatically Number Rows in Excel (10 Easy Ways)

Although Excel does not have built-in Auto-Number features or functions, it provides various features and functions that can be used to generate ...

Editor choice Automatically Number Rows in Excel (10 Easy Ways)

How to Create Multiple Lines in a Single Cell (4 Methods)

Dataset Overview In our dataset, within the first column labeled Test Line, we encounter longer text that doesn’t fit neatly into individual cells. ...

How to Remove Time from Date in Excel (6 Methods)

Method 1 - Using the Format Cells Feature Assuming we have a dataset of Dates with Times. We are going to remove the time part and insert only the ...

How to Remove Dashes from Phone Number in Excel

Method 1 - Applying Find and Replace Feature Select the range of cells where the phone numbers are located. Go to the Home tab > Find ...

Editor choice How to Remove Dashes from Phone Number in Excel

How to Edit a Named Range in Excel

There is a spelling mistake in the named range: Brnd.   How to Edit the Name of a Named Range? To change the Named Range Brnd to ...

How to Display Cell Formulas in Excel (6 Methods)

The image below displays the cell formulas in the Excel worksheet using the Show Formulas command in the Formulas tab. Consider a dataset ...

How to Delete Defined Names in Excel (3 Easy Ways)

Method 1 - Using Formula Tab to Delete Defined Names in Excel Steps: Open the workbook whereyou want to delete the Defined Names. Go to the ...

Editor choice How to Delete Defined Names in Excel (3 Easy Ways)

Excel Find Duplicates in Column and Delete Row (4 Quick Ways)

In a short dataset, we can easily remove duplicates manually but if the dataset becomes large then we need some other quick methods to do it. So ...

How to Automatically Copy Data from One Cell to Another in Excel (4 Methods)

Below is a dataset of a company's Weekly Sales Report. Method 1 – Using Cell Reference  1.1 Copying Data to the Same Sheet Steps: ...

How to Show Formula as Text in Another Cell in Excel (6 Ways)

Consider the List of Employee Salary dataset shown in the B4:F13 cells containing the Job ID, Name, Salary, Allowances, and Total Salary columns, ...

Editor choice How to Show Formula as Text in Another Cell in Excel (6 Ways)
Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo