按ALT+F11,出现VBE窗体,在sheet1上双击,在右边的空白粘贴下面代码; Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Cells.Count = 1 And .Column = 1 Then
.Offset(0, 1).NumberFormatLocal = "yyyy/mm/dd hh:mm:ss"
.Offset(0, 1).Value = Now
End If
End WithEnd Sub 关闭VBE,回到sheet1...