- Image and text skills
How to deal with the error message that pops up when we enter data?
￭If you confirm that there is no problem with this value, select the cell with this error prompt and click Ignore the error.
￭If you want this table to no longer display validity error prompts, you can click "Error Check" to check "Content does not match data validity"
How to check if we want to enter the correct range?
￭Click the "Data" tab, select "Validity",In the pop-up "Data is valid" In the dialog box, we can use the minimum and maximum values to determine the range of values that need to be entered.
￭You can also provide input instructions for the data validity cells in the "Input Information" to prompt others to input the data range to avoid error prompts.
￭Check the "Show error warning" checkbox to decide whether to allow the entry of invalid data. Clicking on the warning style and adding a text description can let others quickly understand the cause of the error. Easy to correct.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/chang-jian-cuo-wu-dan-chuang-yu-jie-jue-fang-fa-dan-yuan-ge-nei-rong-bu-fu-he-xian-zhi-chu-xian-yuan-yin-ji-jie-jue-fang-fa.html
支付宝扫一扫 
评论列表（196条）
测试