Excel: Date Time Shortcut

This is different from the previous tip, that updates the date and/or the time, every time you open Excel. This one will just enter the data in the cell without using a formula. This is a simple keyboard shortcut.

To enter today’s date: Press Ctrl & ; <—– (semicolon key)
To enter current time: Press Ctrl & Shift & : <—– (colon key)

Now you have today’s date or the current time. Unless you change it yourself, it will keep this data in the spreadsheet, without changing it.

 

Joe Austin
 

Joe Austin is the founder of Potentials Unleashed. He is currently an IT Professional Manager in the Financial Industry and has been using computers since 1978. While mostly self-taught, he is proficient in several computing areas, such as Programming , Web Development, most Microsoft Office programs, Internet Marketing, Spyware / Malware Removal and even 3D Animation & Modeling.

Click Here to Leave a Comment Below 0 comments
%d bloggers like this: