Advanced Excel Archives - Page 46 of 61

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Jun 5, 2024

Sometimes due to technical issues AutoFilter gets hidden, or even though there is no filter applied, Excel shows that there is. In both cases, it can ...

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

Nov 11, 2025

In this article, I’ll show you how you can auto-filter values that are not equal to a certain value with VBA in Excel. You’ll learn to auto-filter ...

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

How to Sort Smallest to Largest with VBA Autofilter in Excel: 3 Suitable Ways

Jun 3, 2024

Method 1 - Sort Smallest to Largest Using the Ascending Order in VBA Autofilter Step 1: Open a Module. From your Developer tab, go to Developer ...

How to Sort Smallest to Largest with VBA Autofilter in Excel: 3 Suitable Ways

The AutoFilter Method of Range Class Failed – 5 Solutions

Aug 4, 2024

This is the sample dataset. Solution 1 - Correcting the Field Number Filter sales values greater than 2500: Use this code: Sub ...

The AutoFilter Method of Range Class Failed – 5 Solutions

Edit Links in Excel is not Working – 3 Solutions

Aug 12, 2024

In the sample dataset, data was entered using external links in formulas, but errors are displayed. Solution 1 - Using ...

Edit Links in Excel is not Working – 3 Solutions

How to Create Dependent Drop Down List with Multiple Words in Excel

Nov 11, 2025

While working in Microsoft Excel, sometimes we need to create data entry forms or Excel dashboards. When developing data entry forms, a drop-down ...

How to Create Dependent Drop Down List with Multiple Words in Excel

How to Change Drop Down List Based on Cell Value in Excel (2 Ways)

Apr 30, 2024

In this tutorial, we will run through the two best ways to change drop-down lists. Firstly, we will apply the OFFSET and MATCH functions in the ...

How to Change Drop Down List Based on Cell Value in Excel (2 Ways)

7 Solutions for Greyed Out Edit Links or Change Source Option in Excel

Jul 5, 2024

Solution 1 - Workbooks Must Contain External Links to Enable Greyed Out Edit Links The Edit Link function is used to control links between different ...

7 Solutions for Greyed Out Edit Links or Change Source Option in Excel

The Workbook Contains Links to One or More External Sources That may Be Unsafe – 3 Solutions

Jul 6, 2024

Solution 1 - Fix ‘This Workbook Contains Links to One or More External Sources That Could Be Unsafe’ Error with Automatic Update and No ...

The Workbook Contains Links to One or More External Sources That may Be Unsafe – 3 Solutions

How to Create a Drop Down List Hyperlink to Another Sheet in Excel: 2 Methods

Aug 6, 2024

Method 1 - Create a Drop Down List Hyperlink to Another Sheet Using Formula in Excel Step 1: Select a cell (A2 in the worksheet named ...

How to Create a Drop Down List Hyperlink to Another Sheet in Excel: 2 Methods

How to Find and Replace Values in Multiple Excel Files (3 Methods)

Jul 15, 2024

Method 1 - Multiple Sheets In the following image, you can see that we have an Excel sheet named One. In the same workbook, we have another ...

How to Find and Replace Values in Multiple Excel Files (3 Methods)

Unable to Merge Cells in a Table in Excel? – 3 Solutions

Aug 3, 2024

Reasons why Cells don't Merge in an Excel Table 1- Cells are within the Excel Table: To merge cells in a table, we need to convert it ...

Unable to Merge Cells in a Table in Excel? – 3 Solutions

How to Hyperlink Multiple Cells in Excel (3 Ways)

Aug 6, 2024

In this article, we will describe how to hyperlink multiple cells in Excel using 3 different methods. We'll use the following sample dataset ...

How to Hyperlink Multiple Cells in Excel (3 Ways)

How to Extract Data Based on a Drop Down List in Excel – 6 Steps

Aug 7, 2024

This is the sample dataset. Step 1 - Create a Table to Extract Data Based on a Drop Down List in Excel Select the Table. Click ...

How to Extract Data Based on a Drop Down List in Excel – 6 Steps

How to Link Picture to Cell Value in Excel: 4 Methods

Feb 26, 2026

The example dataset below shows the yearly Sales of various Products. The entire dataset is located in the B4:D13 cell range. Method 1 - ...