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

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

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

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 ...

How to Delete Multiple Rows in Excel Using Formula?

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 Fix #REF! Error in Excel (6 Solutions)

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 Use Flash Fill in Excel to Split Data (4 Quick Ways)

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 Copy Alternate Rows in Excel (4 Ways)

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 ...

[Fixed] Excel Print Error Not Enough Memory

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, ...

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

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 ...

How to Write 001 in Excel (11 Effective Methods)

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 Apply the Advanced Filter to Copy to Another Location in Excel

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 ...

How to Copy a Formula and Paste it as Text in Excel – 2 Methods

Method 1 - Use the Text Import Wizard and the Notepad to Copy a Formula and Paste it as Text in Excel 1.1 Display Cell Formulas The image below ...

Text Alignment with VBA Command Button in Excel (5 Methods)

In this article, we will learn text alignment with the command button in Excel using VBA. Text alignment is a necessary thing to represent a clean ...

How to Remove Blanks from List Using Formula in Excel (4 Methods)

Scenario Let’s consider a scenario where we have an Excel worksheet containing a list of various computer hardware and accessories. Unfortunately, ...

How to Delete Columns Based on the Header Using VBA in Excel – 6 Methods

The sample dataset showcases sold Products, Order Date, City, Category, Quantity, and Unit Price. To delete columns:   Opening ...

How to Copy Data from Another Workbook without Opening with Excel VBA: 3 Different Ways

We will use a sample Workbook named Product_Details and copy the data range (B4:E10) to another Workbook. Method 1 - Copy a Sheet Data ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo