Latest Blog Posts - Page 420 of 584

How to Change Lowercase to Uppercase in Excel (6 Methods)

Jun 13, 2024

We have a dataset containing two columns, Name and Car Maker. We'll transform the values in the Car Maker column into uppercase. How to ...

How to Change Lowercase to Uppercase in Excel (6 Methods)

How to Show All Formulas in Excel – 5 Easy Methods

Aug 3, 2024

In the following overview image all formulas are displayed in the sheet. This is the sample dataset containing Employee Name, Basic ...

How to Show All Formulas in Excel – 5 Easy Methods

[Fixed!] Unable to Change Font Color in Excel (3 Solutions)

Jul 6, 2024

To explain our solutions we will use the dataset below, and try to change the font color in the Age column. Solution 1 - Disable Hardware ...

[Fixed!] Unable to Change Font Color in Excel (3 Solutions)

How to Convert Text to Time Format with AM/PM in Excel (3 Methods)

Nov 11, 2025

Very often we have to input Time in the Excel worksheet for many different purposes. But we may forget to set the format or change the format from ...

How to Convert Text to Time Format with AM/PM in Excel (3 Methods)

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

Count Unique Values with Criteria using the COUNTIFS Function in EXCEL – 4 Examples

Aug 4, 2024

The COUNTIFS Function The COUNTIFS function counts the number of cells in a range that match one of the provided conditions. Syntax COUNTIFS ...

Count Unique Values with Criteria using the COUNTIFS Function in EXCEL – 4 Examples

How to Split Data in Excel – 5 Methods

Aug 3, 2024

The following dataset showcases full names and first and second names. Method 1 - Using Text to Columns Features to Split Data in Excel ...

Interest Only Amortization Schedule with Balloon Payment Template Excel [Free Download]

Jul 14, 2024

Download our free Interest Only Loan Amortization Schedule with Balloon Payment template for Excel to generate your own amortization schedule ...

Interest Only Amortization Schedule with Balloon Payment Template Excel [Free Download]

How to Keep a Running Balance in Excel (8 Methods)

Jun 9, 2024

We've put daily Earnings and Expenses in the first week of February 2022 in our sample dataset. We'll use it to track expenses. How to ...

How to Keep a Running Balance in Excel (8 Methods)

Excel VBA to Match String in Column (5 Examples)

Nov 11, 2025

In Excel, we use both numeric data and string data. They may exist in the same column or the same cell. If we want to find cells with string data, we ...

Excel VBA to Match String in Column (5 Examples)

Excel VBA to Create Named Range from Selection (5 Examples)

Nov 11, 2025

A named range is to set a name for one or more cells. We can call a named range instead of a cell or range. In this article, we will discuss how to ...

Excel VBA to Create Named Range from Selection (5 Examples)

How to Find External Links in Conditional Formatting in Excel (2 Ways)

Nov 11, 2025

Assume your worksheet contains a large number of external links, and you now have to dynamically identify the cells that contain the links and ...

How to Find External Links in Conditional Formatting in Excel (2 Ways)

How to Calculate the Running Total by Group Using the Excel Power Query – 2 Methods

Aug 10, 2024

The dataset showcases Items and Sales over three months. To calculate the running total by group (Month), choose a month: Method 1 - ...

How to Calculate the Running Total by Group Using the Excel Power Query – 2 Methods

How to Add a New Row in an Excel Table

Jun 18, 2024

Watch Video - Add a New Row Automatically in a Table Below is the dataset, which calculates each person's BMI in column ...

Excel Macro to Split Data into Multiple Files: 2 Methods

May 28, 2024

Method 1 - Steps to Create the Excel Macro to Split Data into Multiple Files Open the VBA Editor in Excel Press ALT+F11 to open the VBA editor ...