This article will tell you how to add excel data validation rule to help you to validate the cell input data so that it can avoid inputting incorrect data into the related cell. The data validation rule can also be used to find out the invalid data cells that are not allowed by the validation […]
Excel Data Validation Examples Read More »
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.
How To Select Excel Cells Use Excel Go To Special Dialog Read More »
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
How To Validate Text Data In Excel Read More »
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
How To Validate Date Input In Excel Read More »
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.
Excel Conditional Formatting Examples Read More »
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.
What Is The Difference Between Excel File Format Xlsx And Xls Read More »
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.
How To Automatically Destroy Excel Table Data After Expiration Read More »
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.
Excel Split Data Into Columns Read More »
When you input the date time in Excel, you always need to calculate the date-time between 2 dates. This article will tell you how to calculate the time, hours, days, months, and years between 2 dates in Microsoft Excel with or without Excel functions.
