How to Combine Text and Formatted Values in Excel

In this article, we will learn How to Combine Text and Formatted Values in Excel. Scenario: Excel treats values to many formats like number,...

Copying and Pasting Validation list only in Microsoft Excel

When copying a cell that contains validation criteria to a different cell, the criteria are copied along with the text formula and format. If you wan...

Preventing Duplicates While Entering Data in Excel 2010

In this article we will learn about how to prevent duplicates while entering the data in Microsoft Excel 2010. We can use Countif formula to prevent t...

Quickly Entering a Web Site address Email Address or Company Name in Excel

In this article we will learn about how to quickly enter a Website Address, Email Address and Company Name in Microsoft excel. Auto Correct Option is...

Deleting All Cell Comments in Excel 2016

In this article, we will learn to delete or remove comments in Excel cells. Comments in Excel to remind ourselves and inform someone else about wha...

Quickly Typing Dates into Cells

In this article we will learn about how we can enter the quickly into cells in Microsoft Excel 2013. Typing a large amount of data into cells can b...

Insert Current Date into a Cell in Excel

In this article, we’ll learn how we can return current date into a cell in Microsoft Excel. To return current date, we use TODAY function. In Excel...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.