Excel Tricks

The Excel Go To Special dialog can help you to find and select the cells that meet the special conditions, it is very useful. This article will tell you how to use it to find and select the specified Excel cells with examples.

This article will show you some examples of how to validate text data input in excel cells. The first example shows you how to restrict the input text length. The second example shows you how to allow input text only in the excel cell. The third example shows you how to allow input text that

This article will show you some examples of how to allow input numbers only in excel cells.

When a user inputs a date or time value in an Excel cell, you may want to validate the user input value to check whether the date or time value is correct or not. And when you open an existing worksheet that contains a lot of date-type values, you may want to validate those existing

This article will show you some examples of how to use the excel conditional formatting tool to format cells by conditions in excel. That means it will only format the excel cells that match the condition. It will also tell you how to use a formula to implement excel conditional formatting.

When you save a file with Microsoft Excel, you will find that there are two formats xlsx and xls. You may don’t know which one to choose. This article will tell you the differences between them, the advantages and disadvantages of each file format, so you can select the most appropriate format in different scenarios.

We all know that we can set various conditions for excel tables. Today, let’s take a look at a special operation, that is how to use conditional format settings to set our table data to be automatically destroyed after expiration.

This article will tell you some examples of how to split one cell text data into multiple columns after the cell data column in Excel.

In the previous article, I told you how to convert text to date in Excel using Excel functions and formulas. In this article, I will tell you how to convert text to date in Excel using the Excel Text to Columns wizard. Using this wizard, you do not need to know any Excel functions and

When you use formulas in Excel, you may always encounter errors. In such a case, you may see the text #VALUE! in the cell instead of the value that it should be. Excel provides a feature to check the errors in your worksheet, it can also help you to debug and fix the error. This