370,888 views
42 votes
42 votes
Write the steps to insert date and time in a cell​

User Kaarel Nummert
by
2.4k points

1 Answer

5 votes
5 votes

Answer:

Do one of the following:

To insert the current date, press Ctrl+; (semi-colon).

To insert the current time, press Ctrl+Shift+; (semi-colon).

To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

User Raphael Karanja
by
3.0k points