Video Of Day

Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length

 Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length


Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length With this video, you'll learn how to apply data validation with Text Length or Limit text on any cell. With some sample data, I will show you how to use Data Validation in excel or Use of Data validation in MS excel. Data validation in MS Excel with the Limit of Text length in any cell is the most important for collecting data from end-users. I hope after watching this video you will be able to use it in your daily file.



Step By Step Process:-

Here is my demo Table





1st you need to select the required cell or Column for MS Excel - Data Validation by Text Length

here I used I column as per below picture



01 - Selected required column, Like I ( I have selected here )

02 - Click on data Menu ( As per below picture )

03 - Click on Data Validation ( As per below picture )

04 - Again you need to click on Data Validation ( As per below picture ) then the system will show you a small popup window


05 - From this
small pop-up window please do this 3 step



06 - Please follow the steps below


I hope after following these steps you will be able to use it in your daily file.

https://youtu.be/lELsjvemtOo



Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length Excel Data Validation - Text Length || MS Excel - Data Validation by Text Length Reviewed by Mizanur Rahman on July 24, 2021 Rating: 5

No comments:

Powered by Blogger.