Latest Blog Posts - Page 228 of 586

Create a Search Box in Excel with VBA (5 Suitable Examples)

Jun 14, 2024

We have taken the following table as the dataset. This table contains State, Sales Person, and Product columns. We will create a search box in Excel ...

Create a Search Box in Excel with VBA (5 Suitable Examples)

How to Rename Column in Excel (3 Easy Ways)

Nov 11, 2025

The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the ...

How to Rename Column in Excel (3 Easy Ways)

How to Calculate Remaining Shelf Life Percentage in Excel (With Easy Steps)

Jul 6, 2024

Step 1 - Prepare the Dataset Insert the product names in the Product column. Insert the manufacturing date in the MFG Date column. ...

How to Calculate Remaining Shelf Life Percentage in Excel (With Easy Steps)

How to Compare Dates in Two Columns in Excel (8 Methods)

Jun 9, 2024

Method 1 - Compare Dates in Two Columns Whether They Are Equal or Not Steps: Select an appropriate cell (D5 in this example) and use the ...

How to Compare Dates in Two Columns in Excel (8 Methods)

How to Select Visible Cells in Excel (5 Quick Tricks)

Jul 4, 2024

When working with large data sets containing hidden cells, one can easily select the visible cells along with the hidden cells by dragging the mouse ...

How to Select Visible Cells in Excel (5 Quick Tricks)

How to Refresh Excel Sheet Automatically Using VBA (4 Methods)

Apr 27, 2024

Method 1 - Using the ThisWorkbook Method in VBA to Refresh an Excel Sheet Automatically Step 1 - Creating the Dataset We will create a ...

How to Refresh Excel Sheet Automatically Using VBA (4 Methods)

How to Create a Filtering Search Box for Your Excel Data (5 Methods)

Jun 17, 2024

In the below dataset, we have 3 columns: Customer Name, Region and Product. Method 1 – Using Data Validation Steps: Select a cell ...

How to Create a Filtering Search Box for Your Excel Data (5 Methods)

Add 15 Minutes to Time in Excel: 4 Easy Methods

Jul 3, 2024

Method 1 - Use SUM Function to Add 15 Minutes to Time in Excel Steps: Add a new column on the right side and remove all the minute values. ...

Add 15 Minutes to Time in Excel: 4 Easy Methods

How to Create GST Bill Format in Excel with Formula: 4 Methods

Jun 21, 2024

Method 1 - Create Outline of GST Bill Format Create a basic dataset of the products, like the image below. We need to create another ...

How to Create GST Bill Format in Excel with Formula: 4 Methods

How to Cut Text Using Formula in Excel (6 Simple Methods)

Jul 6, 2024

Method 1 - Combine LEFT and FIND Functions to Cut Text in Excel To cut the first text from cell B5 of the dataset, we will use the LEFT and FIND ...

How to Cut Text Using Formula in Excel (6 Simple Methods)

VBA Read Text File into Array (2 Suitable Methods)

Nov 11, 2025

While working in Excel, we often need to read and extract texts from a text file into array using VBA code. For a small text file, we can do this ...

VBA Read Text File into Array (2 Suitable Methods)

How to Add Sheet After Current One with Excel VBA (3 Variants)

Jul 31, 2024

Basics of VBA Sheets.Add Method Sheets.Add is a method that is used to add a new worksheet to the current worksheet. This method is used while ...

How to Add Sheet After Current One with Excel VBA (3 Variants)

How to Create a Scoring Matrix in Excel (Easy Steps)

Jul 25, 2024

What is a Scoring Matrix and Where Do We Use It? A scoring matrix is a valuable tool for assessing the relative worth of various items, such as ...

How to Create a Scoring Matrix in Excel (Easy Steps)

How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

Jul 3, 2024

We have a large dataset that we need to select rows from. Method 1 - Using the Name Box to Quickly Select Thousands of Rows Steps: ...

How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

How to Find Row Number Using VBA in Excel (4 Macros)

Jul 6, 2024

Macro 1 - VBA to Find Row Number by Changing Selection Steps: Right-click on the sheet title and select View Code from the context menu. ...