Latest Blog Posts - Page 443 of 584

Formula to Copy Cell Value and Format in Excel (5 Ways)

May 21, 2024

In this sample dataset, the Name values are in Text format, Weekly Income is in Currency Format and other cells are formatted with text and cell ...

Formula to Copy Cell Value and Format in Excel (5 Ways)

How to Create a Formula in Excel without Using a Function (6 Approaches)

Nov 11, 2025

Excel is one of the most useful tools we are familiar with. It enables us to perform myriads of calculations applying the functions available in ...

How to Create a Formula in Excel without Using a Function (6 Approaches)

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel (5 Methods)

Jul 6, 2024

We have a dataset that contains information about several projects. The project names, managers of those projects, and estimated costs of those ...

How to Use COUNTIF with Multiple Criteria in the Same Column in Excel (5 Methods)

Excel VBA: Getting the Cell Value from Another Workbook without Opening it – 2 Examples

Aug 3, 2024

How to Launch the VBA Editor in Excel Go to the Developer tab. Select Visual Basic. A new window will open. Select Insert, ...

Excel VBA: Getting the Cell Value from Another Workbook without Opening it – 2 Examples

How to Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

Jun 16, 2024

In the dataset below, the Sales Report for January is provided, and some cells are blank. Method 1 – Using a Simple Formula Steps: ...

How to Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

How to Format Cell Based on Formula in Excel (13 Useful Examples)

May 8, 2024

The following dataset represents the Devices of several Brands, Models, and Prices of those Devices. We will use it to demonstrate how to format ...

How to Format Cell Based on Formula in Excel (13 Useful Examples)

Excel VBA Codes to Bold Text in a String (5 Examples)

Jun 18, 2024

In this tutorial, you will learn how to make a text bold in a string using Excel VBA, along with other related tasks. Example 1 - Bold the ...

Excel VBA Codes to Bold Text in a String (5 Examples)

How to Delete Multiple Rows in Excel Using Formula?

Jul 29, 2024

We will be applying 5 methods to remove rows. We'll use a sample dataset with four columns, Car Name, Company Name, Price, and Max Speed (Mph). ...

How to Delete Multiple Rows in Excel Using Formula?

How to Fix #REF! Error in Excel (6 Solutions)

Jul 12, 2024

Understanding the #REF! Error in Excel The #REF! error occurs when a cell reference becomes invalid or nonexistent. Here are the common scenarios ...

How to Fix #REF! Error in Excel (6 Solutions)

How to Use Flash Fill in Excel to Split Data (4 Quick Ways)

Nov 11, 2025

In this article, we will learn how to use Flash Fill in Excel to Split Data. There are several ways to Split data into several columns in Excel like ...

How to Use Flash Fill in Excel to Split Data (4 Quick Ways)

How to Copy Alternate Rows in Excel (4 Ways)

Jun 19, 2024

We'll use the following sample dataset to copy alternate rows from it. Method 1 - Hold the Ctrl Key and Select to Copy Alternate Rows in Excel ...

How to Copy Alternate Rows in Excel (4 Ways)

[Fixed] Excel Print Error Not Enough Memory

Jun 18, 2024

You might receive the error message below when trying to print an Excel file (.xlsx or .xlsm). There are several possible reasons for this error, ...

[Fixed] Excel Print Error Not Enough Memory

Filling a Certain Number of Rows in Excel Automatically: 6 Methods

May 25, 2024

Method 1 - Making Pattern and Using Fill Handle for Filling a Certain Number of Excel Rows Make a pattern of numbers. Fill Handle will allow us to ...

Filling a Certain Number of Rows in Excel Automatically: 6 Methods

How to Write 001 in Excel (11 Effective Methods)

May 29, 2024

Excel automatically removes the leading zeros from a number when entered in a cell, making it impossible to write 001. Below, learn 11 possible ways ...

How to Write 001 in Excel (11 Effective Methods)

How to Apply the Advanced Filter to Copy to Another Location in Excel

Nov 11, 2025

Advanced Filter is one of the most useful and advantageous features of Excel that’s used pretty often to copy one range of cells from one location to ...