:Fault serial number automatically generated-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Fault serial number automatically generated

Fault serial number automatically generated

Author: daogeziyuan • • Table skills • Views 1041
  • Image and text skills


Using the traditional filling method to fill the serial number, gaps will occur when a certain row is deleted. How to solve this problem?


图片1.gif


图文对齐图.png


￭First enter "=ROW()-the number of rows in the previous row" in serial number 1,that is, "=ROW()- 1";

Press the Enter key, place the cursor in the lower right corner of the cell and pull down the fill when it forms a + shape,

Delete a line at will at this time, and the serial number will not be broken~


图片2.gif


Have you mastered this skill?


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/duan-ceng-xu-hao-zi-dong-sheng-cheng.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu N Columnist
48 196
single-end

Related Suggestion