Excel Basics

VBA to Concatenate Range with Separator in Excel (3 Ways)

In this article, I’ll show you how you can concatenate a range of cells with a given separator using VBA in Excel. You’ll learn to concatenate the ...

How to Hide Zero Values in Excel Pivot Table (3 Easy Methods)

Pivot table is one of the essential tools of Microsoft Excel. If you have worked with that, you might know that. It gives us a detailed view and ...

How to Highlight Row If Cell Is Not Blank (4 Methods)

Conditional Formatting feature in Excel gives you different options to highlight cells of your dataset based on different conditions. You can ...

Conditional Formatting Entire Column Based on Another Column(6 Steps)

In Excel, conditional formatting is used to highlight any cells based on predetermined criteria and the value of those cells. We can also apply ...

How to Remove Scientific Notation in Excel (4 Quick Ways)

In Microsoft Excel, large and small numbers are stored automatically into Scientific Notation by default. Excel has a number limit which is 15 ...

3 Methods to Convert Scientific Notation to Text in Excel

In Microsoft Excel, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the ...

How to Paste Range Names in Excel (7 Ways)

If you are looking for some of the easiest ways to paste range names in Excel, then you are in the right place. Pasting range names will make your ...

How to Highlight Cells in Excel Based on Value (9 Methods)

In Excel, you can use various methods to highlight cells based on their value. In this article, I’ll show you 9 methods by which you can highlight ...

VALUE Error in Excel: 7 Reasons with Solutions

Every now and then we get a VALUE error in Excel. According to the Microsoft site, “VALUE is Excel's way of saying, there's something wrong with the ...

Excel Table Formatting Problems (with Solutions)

Excel is a very common application for people who work with data. We can collect, store, process, and get information from raw data using Excel. The ...

Excel Macro to Add Row to the Bottom of a Table

In this article, I’ll show you how you can develop a Macro to add a new row to the bottom of a table in Excel. You’ll learn to add an empty new row ...

[Fixed!] Excel Not Recognizing Numbers in Cells (3 Techniques)

While working with Microsoft Excel, you may find yourself in a situation where Excel won't recognize your numbers. Sometimes, we collect data from ...

Reasons and Corrections of NAME Error in Excel (10 Examples)

If you are looking for the reasons and corrections of NAME Error in Excel, then you are in the right place. Sometimes working with a dataset in ...

How to Name a Group of Cells in Excel (3 Methods +1 Bonus)

A typical Excel spreadsheet may contain formulas that are made of different cell ranges. It can be difficult to remember these cell ranges and re-use ...

Highlight Row If Cell Contains Any Text

In this article, we will discuss how to highlight a row if any cell contains any text. Sometimes highlighting only the cells that contain text is not ...

ExcelDemy
Logo