Latest Blog Posts - Page 438 of 589

Create a Searchable Drop Down List in Excel (2 Methods)

Apr 19, 2024

The following picture highlights what you can do with a searchable drop-down. Imagine you have the following dataset in the worksheet ...

Create a Searchable Drop Down List in Excel (2 Methods)

How to Use a Custom VLOOKUP Formula in Excel Data Validation – 2 Methods

Aug 8, 2024

The sample dataset showcases sales in different regions. Method 1 - Using a Drop-down List of Data Validation with the VLOOKUP Function in ...

How to Use a Custom VLOOKUP Formula in Excel Data Validation – 2 Methods

Excel VBA: Count Unique Values in a Column (3 Methods)

Jul 6, 2024

Overview of the Code Sub Number_of_Values_that_Appear_Only_Once_1() Set Rng = Range("C4:C15") Count = 0 For i = 1 To ...

Excel VBA: Count Unique Values in a Column (3 Methods)

Excel VBA with Cell Reference by Row and Column Number – 11 Examples

Aug 9, 2024

This is the sample dataset. Example 1 - Insert a Value in a Single Cell Using Reference by Row and Column Number with Excel VBA Step 1: ...

Excel VBA with Cell Reference by Row and Column Number – 11 Examples

How to Find and Replace Cell Reference in Excel Formula

Nov 11, 2025

Most of the time we use a cell reference in an Excel formula. However, often we have to update the formula based on different situations. Now, if you ...

How to Find and Replace Cell Reference in Excel Formula

How to Convert Date to Month and Year in Excel (4 Ways)

Jun 14, 2024

Suppose we have a dataset of several employees with DoB (date of birth) in column C. We want to convert the date to month and year only for ...

How to Convert Date to Month and Year in Excel (4 Ways)

The AutoFit Row Height is Not Working for Merged Cells in Excel – 2 Solutions

Aug 8, 2024

Solution 1 - Use an Updated Version of MS Excel (2010, 2013, 2016, 2019, 2021, 365 Versions) This is the sample dataset. The Product column ...

The AutoFit Row Height is Not Working for Merged Cells in Excel – 2 Solutions

How to Change Date Format in Excel Using Formula

Jun 23, 2024

To change date format using a formula in Excel: Select a cell. Insert the formula: =TEXT(Reference Cell,"Date Format") Press Enter. For ...

How to Change Date Format in Excel Using Formula

Excel VBA: Filter Date before Today (With Quick Steps)

Nov 11, 2025

In Microsoft Excel, working with dates is a pretty common thing. And filtering those dates is also a day-to-day task for a lot of Excel users. Now, ...

Excel VBA: Filter Date before Today (With Quick Steps)

Excel VBA: Count Rows in Named Range (4 Methods)

Nov 11, 2025

We can count rows in a named range by using workbook functions or conditional formatting but if we work with a large amount of data then using VBA ...

Excel VBA: Count Rows in Named Range (4 Methods)

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

Jun 27, 2024

A typical problem with arrow keys is that they move the spreadsheet but not the pointer. In this tutorial, we will illustrate how to fix arrow keys ...

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

Jul 4, 2024

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores ...

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

How to Use Named Range for Data Validation List with VBA in Excel

Nov 11, 2025

If you are looking for the easiest ways to use named range for data validation list in Excel VBA, then you will find this article useful. Named ...

How to Use Named Range for Data Validation List with VBA in Excel

How to Get First Day of Month from Month Name in Excel (3 Ways)

Nov 11, 2025

During our work with Excel, sometimes we need to know the first day of the given month or date. But there is no direct function or formula in Excel ...

How to Get First Day of Month from Month Name in Excel (3 Ways)

How to Get Last Day of Previous Month in Excel (3 Methods)

Jul 5, 2024

The sample dataset contains a list of dates in column B. We'll find the last day of the previous month in column C. Method 1 - ...