Advanced Excel Archives - Page 53 of 63

How to Use an Advanced Filter If the Criteria Range Contains Text in Excel – 5 Methods

Aug 13, 2024

This is the sample dataset. Method 1 - Using an Advanced Filter for a Cell That Contains Unique Text Values The dataset ...

How to Use an Advanced Filter If the Criteria Range Contains Text in Excel – 5 Methods

How to Insert the Excel Date Picker for an Entire Column

Jul 15, 2024

What is Excel Date Picker? The Excel Date Picker is a handy feature in Microsoft Excel. It provides a calendar pop-up that allows users to select ...

How to Insert the Excel Date Picker for an Entire Column

Print Preview in Excel

Nov 11, 2025

In this article, we will discuss the print preview in Excel and understand their significance. In various professional fields such as business, ...

Creating a Mailing List in Excel (2 Methods)

Jun 16, 2024

Let’s say our company name is Marigold Sales, and the address has changed from 7 Oak Valley St., Lakeland, Florida 33801 to Marigold Sales, 71 ...

Creating a Mailing List in Excel (2 Methods)

How to Allow Circular Reference in Excel (With 2 Suitable Uses)

Nov 11, 2025

"Allow Circular Reference in Excel" is an easy way to insert self-reference a cell in Excel. By Microsoft’s definition, Circular Reference occurs ...

How to Allow Circular Reference in Excel (With 2 Suitable Uses)

How to Make a Numbered List in Excel (8 Methods)

Jul 22, 2024

Dataset Overview We have a dataset that contains information about 10 different students. Student names and their identification numbers are ...

How to Make a Numbered List in Excel (8 Methods)

How to Make a List within a Cell in Excel (3 Quick Methods)

Jul 6, 2024

Method 1 - Creating a Bullet Or Number List within a Cell in Excel Double-click the cell where you want to create the list. Go to Insert > ...

How to Make a List within a Cell in Excel (3 Quick Methods)

How to Filter by Color in Excel (2 Examples)

Nov 11, 2025

In financial big data analysis, you could find that applying a filter to your analysis helps you examine your data more effectively. When data is ...

How to Filter by Color in Excel (2 Examples)

Print Titles in Excel

Nov 11, 2025

In this article, we will provide valuable insights on how to effectively print titles in Excel, enabling you to create well-organized and visually ...

How to Highlight Active Row in Excel (3 Methods)

Jul 3, 2024

We'll use the following sample dataset to highlight a row whenever we select a cell in that row. Method 1 - Highlighting the Active Row by ...

How to Highlight Active Row in Excel (3 Methods)

How to Add Filter in Excel (4 Simple Methods)

Apr 29, 2024

Consider the following data as a product price list. We have added a filter to the data. The drop-down icons at the right-bottom corners of the ...

How to Add Filter in Excel (4 Simple Methods)

How to Filter Unique Values in Excel (8 Easy Ways)

Apr 29, 2024

Let’s say we have three simple columns in an Excel dataset containing Order Date, Category, and Product information. We want the unique ordered ...

How to Filter Unique Values in Excel (8 Easy Ways)

How to Make a Price List in Excel (Step by Step Guidelines)

Jul 6, 2024

Step 1 - Making an Outline of the Price List Template We'll start with the following dataset that contains various product details, including ...

How to Make a Price List in Excel (Step by Step Guidelines)

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Jun 14, 2024

Let’s say we have the following dataset: Sales Representative's Name, their Sales Area, and the Number of Units Sold in each month of the first ...

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

Jul 6, 2024

Method 1 - Use the COUNTIF Function to Highlight Cells That Have Text from a List We have a list of Fruit 1 (B4:B14) containing several fruit names. ...