Advanced Excel Archives - Page 58 of 63

How to Make Multiple Selection from Drop Down List in Excel

Jul 3, 2024

We'll use a simple dataset to create a multi-selection drop-down. Method 1 - Making Multiple Selections from an Excel Drop-Down List with ...

How to Make Multiple Selection from Drop Down List in Excel

How to Extract Data From Table Based on Multiple Criteria in Excel

Jul 3, 2024

We have a dataset of movies, their genres, leading actors, and years of release. We will provide the Genre and Actor name as criteria in a ...

How to Extract Data From Table Based on Multiple Criteria in Excel

How to Generate List Based on Criteria in Excel (5 Methods)

Jul 3, 2024

We have a dataset of several people from different locations along with their vehicles. Using this data, we will form a list based on criteria. ...

How to Generate List Based on Criteria in Excel (5 Methods)

Create a Unique List in Excel Based on Criteria (9 Methods)

Jun 16, 2024

Method 1 - Create a List of Unique Rows with Multiple Column Criteria In the following dataset, we have a list of players, their ages, and what ...

Create a Unique List in Excel Based on Criteria (9 Methods)

How to Populate List Based on Cell Value in Excel (8 Methods)

Jun 25, 2024

We have the employee names of the respective departments. We'll populate the list of employees based on a department. Method 1 - ...

How to Populate List Based on Cell Value in Excel (8 Methods)

How to Split One Cell into Two in Excel (5 Useful Methods)

Jun 28, 2024

We have a dataset where column B consists of full names. We have to split the cells of column B into two columns, e.g., first name and last ...

How to Split One Cell into Two in Excel (5 Useful Methods)

How to Split a Cell using a Delimiter in an Excel Formula – 8 Methods

Aug 10, 2024

The dataset showcases students' Name, ID, Course and City. The examples below will be stored in separate sheets. Method 1 - ...

How to Split a Cell using a Delimiter in an Excel Formula – 8 Methods

How to Convert Number to Text with Leading Zeros in Excel: 9 Methods

May 29, 2024

Method 1 - Using Text Format to Convert a Number in Excel with Leading Zeros Steps Select a blank cell or cell range where you want to use the ...

How to Convert Number to Text with Leading Zeros in Excel: 9 Methods

How to Convert Number to Words in Excel (4 Suitable Ways)

Jul 2, 2024

Method 1 - Using the LEFT, MID, TEXT, and CHOOSE Functions in Excel to Convert Numbers to Words We will convert the numbers into the Numbers in ...

How to Convert Number to Words in Excel (4 Suitable Ways)

How to Remove Commas in Excel – 4 Methods

Aug 2, 2024

Method 1 - Converting Commas to Decimal Points to Remove Commas from Numbers The following dataset contains Numbers with Commas. To convert the ...

How to Remove Commas in Excel – 4 Methods

Division Formula in Excel for Multiple Cells: 5 Suitable Methods

May 31, 2024

Method 1 - Applying Formula to Divide Entire Column Values by Specific Number in Excel Steps: In the cell C5, insert this formula: =B5/10 ...

Division Formula in Excel for Multiple Cells: 5 Suitable Methods

How to Split a Single Cell in Half in Excel

Apr 30, 2024

Excel has a lot of features that are meant for performing enormous operations and formatting. You may need to add two different types of headings in ...

How to Split a Single Cell in Half in Excel

How to Insert Square Root Symbol in Excel (8 Easy Ways)

Jul 10, 2024

Here's an overview of inserting the square root symbol via various methods. Method 1 - Using the Insert Tab to Insert the Square Root Symbol ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

How to Add the Footer Page 1 to the Current Worksheet

Nov 11, 2025

When dealing with a worksheet that has a lot of data pages, it is essential to set the proper page numbers for them. Otherwise, it will be difficult ...

How to Add the Footer Page 1 to the Current Worksheet

Perform Commands to Center the Selected Worksheets in Excel

Aug 2, 2024

Method 1 - Using the Custom Margins Feature to Center Selected Worksheets in Excel Case 1.1 - Selecting Multiple Worksheets Steps: Go to ...