Excel Validation - Control What is Entered in Excel

2005年8月6日 - By default, every cell in Excel is set to allow any value. ... In the worksheet below, you want to limit cell B1 to accept only integers between 1 and ...

www.mrexcel.com