Latest Posts

How to Fix Circular Reference Error in Excel (A Detailed Guideline)

While trying to enter a formula in your Excel sheet, it doesn’t function for some reason. Rather, it informs you of a circular reference. Millions of ...

How to Use an Excel Table with VBA (9 Possible Ways)

The Table is one of the most important and widely used objects that we use while working with VBA in Excel. In this article, I’ll show you how you ...

How to Get Excel Sheet Name (2 Methods)

This article illustrates 2 convenient ways to get the sheet name in Excel. The sheet name is a name property of the Worksheet Object in Excel. ...

How to Format Number with VBA in Excel (3 Methods)

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to ...

How to Insert a Picture in Excel Header

Someone can feel it odd to add pictures in an Excel header. But adding images to a spreadsheet header can be necessary in many cases. When we list ...

How to Use Number Format Code in Excel (13 Ways)

This article illustrates the use of number format code in Excel to change the appearance of a number. The actual number doesn’t change, shown in the ...

How to Use Excel Table Reference (10 Ways)

If you are looking for some of the easiest ways to use Excel Table reference, then you are in the right place. Using Table references you can perform ...

Example of Relative Cell Reference in Excel (3 Uses)

Relative Cell Reference in Excel is one kind of cell reference where the referred cell changes when it is copied, moved or used in an array. It is a ...

How to Create a Cash Bill Format in Excel (A step-by-step Guideline)

If you are a shop owner or have a small business, you might need a cash bill invoice to give to your customers with the cost of each purchased item ...

How to Replace Special Characters in Excel (6 Ways)

When working with text data in Excel, we may need to replace specific characters that are superfluous. To simplify the task, we'll replace those ...

How to Use Less Than Or Equal to Operator in Excel (8 Examples)

Microsoft Excel has 6 logical operators which are also known as comparison operators. And Less Than or Equal to (<=) is one of them. The Less Than ...

Create Excel Drop Down List from Table (5 Examples)

In Microsoft Excel, creating a drop down list from the table is very easy. In this article, we will explain the process of creating an excel ...

How to Count Rows with Formula in Excel (5 Quick Methods)

In this tutorial, I will explain some methods to count the number of rows using Excel Formula.  Usually, we can get the row count by simply clicking ...

How to Merge Multiple Sheets into One Sheet with VBA in Excel (2 Ways)

In this article, I’ll show you how you can merge data sets from multiple sheets into one sheet with VBA in Excel. Download Practice Workbook ...

How to Calculate Total Hours in Excel (9 Easy Methods)

While working in Excel, often we need to calculate total hours. For example, you can estimate the total hours required for a certain project from a ...

ExcelDemy
Logo