Latest Blog Posts - Page 427 of 584

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Aug 3, 2024

Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

How to Hide Cell Contents in Excel Formula Bar (5 Methods)

Nov 11, 2025

If you are looking for some easy ways to hide the cell contents in the Excel Formula Bar then this article will be helpful for you. Here, we’ll ...

How to Hide Cell Contents in Excel Formula Bar (5 Methods)

How to Group Cells in Excel (6 Different Ways)

Apr 19, 2024

To group cells in Excel, we are going to use the following dataset. It contains some products in column B, the name of the brand of those ...

How to Group Cells in Excel (6 Different Ways)

Create a Drop-down List Using the INDIRECT Function in Excel – 2 Methods

Aug 13, 2024

This is an overview. The Excel INDIRECT Function Objective: Create a reference from a text string. References created will not change ...

Create a Drop-down List Using the INDIRECT Function in Excel – 2 Methods

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Aug 7, 2024

You have pictures in a specific folder and want to insert one of these pictures in your Excel worksheet. Go to the Developer tab. ...

Excel VBA: Inserting a Picture from the Folder – 3 Methods

Excel VBA Pivot Table to Filter Between Two Dates

Jul 22, 2024

Suppose we have a huge dataset but we just want the data between two specific dates. Filtering a Pivot Table with VBA is an effective, quick, and ...

Excel VBA Pivot Table to Filter Between Two Dates

[Fixed!] Formula Result Showing 0 in Excel (3 Solutions)

Jun 16, 2024

Fix 1 - Fix Formula Result Showing 0 by Converting Text to Number You'll need to check the data in the dataset that is being used in the ...

[Fixed!] Formula Result Showing 0 in Excel (3 Solutions)

Count Rows in Group with Pivot Table in Excel (Step-by-Step Guideline)

Jul 4, 2024

We have a sample dataset containing several fruits and their corresponding fruit types. We'll calculate the number of rows from column B that contain ...

Count Rows in Group with Pivot Table in Excel (Step-by-Step Guideline)

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

Aug 10, 2024

Example 1 - Using the Copy Pasting Tool You have an image in your worksheet. To add this image to the UserForm dialog box: ...

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Jul 24, 2024

Dataset Overview We'll use a dataset that holds products sold on certain days. The products that have sold a Quantity of more than 50 (>50) are ...

How to Use a Formula to Find Bold Text in Excel (4 Methods)

How to Insert a Picture as Cell Background in Excel – 3 Methods

May 4, 2024

The dataset has three columns: Product, Size, and Color. Method 1 - Utilizing the Insert Tab to Insert a Picture as Cell Background Images ...

How to Insert a Picture as Cell Background in Excel – 3 Methods

How to Use VLOOKUP with a Column Index Number to Find Values from Another Sheet (2 Methods)

Jul 10, 2024

Dataset Overview In the screenshot below, you’ll find a sample dataset that we’ll use to demonstrate the two methods. Syntax of the ...

How to Use VLOOKUP with a Column Index Number to Find Values from Another Sheet (2 Methods)

How to Find and Replace Using a Formula in Excel – 4 Examples

Aug 3, 2024

This is the dataset. Example 1 - Using Excel FIND and REPLACE Functions Steps: Create a new column (Actor's Short Name, here) and ...

How to Find and Replace Using a Formula in Excel – 4 Examples

How to Reduce the Size of Formula Bar in Excel (3 Ways)

Nov 11, 2025

Reducing the size of the formula bar in Excel saves space for a clear view. The formula bar is located below the toolbar, which displays the contents ...

How to Reduce the Size of Formula Bar in Excel (3 Ways)

Find and Replace a Text in a Range with Excel VBA (Macro and UserForm)

Nov 11, 2025

In this article, I’ll show you how you can use Excel VBA to find a specific text and replace it with another text within any range in a worksheet. ...