- Image and text skills
When entering formulas in the table,sometimes a warning window will appearRemind us that there is an error in entering the formula.This is an error caused by not entering the formula correctly< span style="font-size: 16px;">Warning,encountered this situationHow to deal with it?
▪Take the SUM function as an example,When this prompt box appears,First click OK to close the error window,Then select the edit bar,Frame the required area
Press Enter to confirm,The error prompt box will disappear,Therefore, only if you enter a complete and correct formula, will no error prompt box appear.
▪ appears In the case of an error prompt box,we do not want to continue entering the function,but I found that no matter where I clicked, I couldn’t cancel the pop-up window. At this time, click the OK button in the error prompt box. Then click the "Cancel" button on the left side of the edit bar to cancel the formula input.
▪If you want to enter a formula in the table but do not want the calculation result, As shown in the video, just need to add " in English input method state before the formula Single quotation mark"Then press enterClick to confirm.
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-ru-he-chu-li-gong-shi-cuo-wu.html
支付宝扫一扫 
评论列表（196条）
测试