excel如何在输入数据后在后面的单元格中自动显示录入数据的时间？
最新回答
-凉薄少年葬空城
2024-11-04 03:57:22
/iknow-pic.cdn.bcebos.com/b7fd5266d0160924fcb6eee1da0735fae7cd34bc"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b7fd5266d0160924fcb6eee1da0735fae7cd34bc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b7fd5266d0160924fcb6eee1da0735fae7cd34bc
"/>2、设置需要显示录入数据时间的单元格格式为时间格式
/iknow-pic.cdn.bcebos.com/4b90f603738da97742f0cdd1be51f8198718e369"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4b90f603738da97742f0cdd1be51f8198718e369?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/4b90f603738da97742f0cdd1be51f8198718e369
"/>3、利用填充功能向下拉动，自动填充下方单元格的公式，在数据列输入数据后，录入时间列自动显示录入数据时的时间，如需重新录入数据，需先删除原数据再录入，以便函数运行，否则时间会不更新
/iknow-pic.cdn.bcebos.com/2e2eb9389b504fc22d12faffebdde71191ef6dff"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/2e2eb9389b504fc22d12faffebdde71191ef6dff?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc22d12faffebdde71191ef6dff
"/>
热门标签
