Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Excel: Shortcut to display current date or time on a cell

No comments
While I was having my lunch on my table, I was conversing with Paul (the programmer). I ask him, "How long you can enter date or time in a spreadsheet cell?". He answered me with - "I can do it in less than 4 seconds". Impressive? NO. Because I can do it in a second. He's cannot believe it so he ask me to prove it.

To display current date or time on a cell quickly, you just need to press two (2) keys:


- To display the date, select a cell then press "CTRL + ;"
- To display the time, select a cell then press "CTRL + :"


Try it for yourself. See? you just need a second to do it.

No comments :

Post a Comment