Advanced Excel Archives - Page 59 of 64

How to Merge Rows Based on Criteria in Excel (4 Easy Ways)

Jul 9, 2024

We'll use the following dataset consisting of 3 columns named Author, Books, Price, and 9 rows contained in the Cell range B4:D12. We'll merge rows ...

How to Merge Rows Based on Criteria in Excel (4 Easy Ways)

How to Link a Table in Excel to Another Sheet – 2 Methods

Aug 14, 2024

There are 2 worksheets: Sheet1 and Sheet2. In Sheet1, you have students' marks in Physics. In Sheet2, students' marks in Chemistry . ...

How to Link a Table in Excel to Another Sheet – 2 Methods

How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)

Aug 6, 2024

We have a worksheet called Sheet1 with the names of some students and their marks. We will add hyperlinks to this sheet in another worksheet of the ...

How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)

How to Remove External Links in Excel (8 Easy Methods)

May 4, 2024

Method 1 - Using Edit Links Feature to Remove External Links from Cells Steps: Go to the Data tab. From the Queries & ...

How to Remove External Links in Excel (8 Easy Methods)

How to Create Multiple Dependent Drop Down Lists with Excel VBA – 3 Methods

Aug 2, 2024

What Are Dependent Drop Down Lists in Excel? Using a dependent drop-down list, you can change the value of a drop-down list and it will show the ...

How to Create Multiple Dependent Drop Down Lists with Excel VBA – 3 Methods

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