If you want to apply a small tweak to the document, it must not require much time to Limit spreadsheet article. Such a basic activity does not have to demand extra training or running through handbooks to understand it. With the appropriate document editing instrument, you will not take more time than is needed for such a swift change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it’s your first time using an online editor service. This tool will require minutes to learn how to Limit spreadsheet article. The sole thing required to get more effective with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the amount of time you need to dedicate to document editing regardless of your previous knowledge of such tools. Make an account now and boost your productivity immediately with DocHub!
okay lets say for example I have a Google spreadsheet and I want to limit anyone in this area here in this column from typing in anything other than a certain number or a certain character but I just want to do this for one character or one number so I dont want to do a drop-down so Im just gonna highlight the cells go to data data validation and it will see that whatever is listed here is what has been highlighted here we will select this and choose lets say I want to have the number one in every single box and thats the only thing anyone can put in I choose number instead of between I choose equal to and then I type in the number one and I am going to instead of showing the warning Im going to reject the input if anybody puts in anything else other than one you also have other options if you wanted it to be between certain numbers not greater than or not equal to what Im gonna choose equal to and then just hit save so now Im going to type in 1 1 1 watch what happens when I t