Latest Blog Posts

How to Add a Row to the Bottom of a Table Using an Excel Macro (2 Methods)

Dataset Overview In this article, we’ve got a table named Table1 in an Excel worksheet that contains the names, starting salaries, and present ...

How to Copy Values to Another Cell If Two Cells Match in Excel: 3 Methods

In this article, we will use a sample product price list as a dataset to demonstrate all the methods.   Method 1 - Use IF Function ...

How to get Excel to Recognize Numbers in Cells (3 Techniques)

Below is a dataset with some formatted numbers. Method 1 – Using the Number Format Command  Steps:  Select the range of cells B5:B10. ...

[Fixed!] NAME Error in Excel (7 Reasons with Solutions)

Excel is a powerful tool widely used for data analysis, organization, and reporting. While working with formulas and functions, you may come across a ...

How to Name a Group of Cells in Excel (3 Easy Methods)

Although naming ranges of cells is one of the most useful features in Excel, making formulas more readable, easy to understand, and maintainable, it ...

How to Highlight Row If Cell Contains Any Text in Excel

Here's a GIF overview of using conditional formatting to highlight rows based on certain values inside them. How to Highlight Row If the ...

How to Edit Defined Names in Excel: 2 Methods

Step 1 - Opening the Name Manager Window in Excel Go to the Formulas tab. Click on Name Manager from the Defined Names group. The Name ...

Table Name in Excel: All You Need to Know

A table in Excel is a list of data with multiple rows and columns. What Excel tables offer more than a conventional data list is Excel tables ...

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

Method 1 - Using Find and Replace Step 1: Go to Home Tab > Select Find & Select (in Editing section) > Click on Replace (from the ...

How to Remove Number Error in Excel (3 Ways)

While working in an Excel worksheet, you may meet error values in using formulas and other situations. Among those errors, number error is quite ...

How to Remove Letters from Cell in Excel (10 Suitable Methods)

Here's a quick overview of the function that can remove text based on how many characters you want to keep. Read on to learn all the methods you can ...

Define Names with the Create from Selection Tool in Excel (2 Examples)

There are a lot of built-in tools in Excel which make our work easier and increase the work speed. If we use names, we can make your formulas much ...

VBA to Remove Formulas in Excel Keeping Values and Formatting

In this article, I’ll show you how you can remove formulas from a worksheet in Excel keeping the values and formatting with VBA. First, you’ll learn ...

How to Remove Error in Excel: 8 Methods

Method 1 - Using Go To Special to Remove Error Remove errors; use the Go To Special. Open the Home tab >> go to Editing group >> from ...

How to Apply Conditional Formatting to Multiple Rows (5 Ways)

Without a doubt, Conditional Formatting is a nifty feature of Excel that allows us to highlight cells based on any criteria. So, we can, at a glance, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo