How to Get Current Date and Time in Excel with a Click
Many times you are supposed to enter the current date or time in excel so here is what you do; simply go to the cell and enter control + colon and the current date is added.
If you want the time to be recorded, it is control + shift + colon.
If you want both; it is control + colon space and then control + shift + colon. The hit enter.
This does save a lot of time for me and am sure will save a lot for you as well
Excel Is Simple is an attempt to help people understand the basics of MS Excel. After all excel is not a demon that many have promoted it as. Week on week we will try to help you with this application, the usage, formula and resolve the queries that people might have.