Then press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box.Ģ. Click the button at the top left corner of worksheet to select all cells. This section will talking about preventing data entry into specific cells by protecting the worksheet.ġ. Prevent data entry into specific cells by protecting the worksheet But after removing data from the range, no data entry can be allowed. Note: You can remove data from this range. And then click the OK button.įrom now on, data entry in this specified cells will cause error as below screenshot shown.
Click the Error Alert tab, enter message into the Error message box that you will use to remind others when they attempt to entering data in specified cells. In the Data Validation dialog box, under the Settings tab, select Text length from the Allow drop-down list, choose equal to option from the equal to drop-down list, then enter number 0 into the length box.ģ. Select the cells you need to prevent data entry, then click Data > Data Validation > Data Validation. If you just want to prevent no data entry into specific cells but allow data deleted, you can try the data validation method.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 kommentar(er)
