With one click enter the current date and time in excel spreadsheet - Simple excel keyboard shortcut
Excel Is Simple
With one click enter the current date and time in an excel spreadsheet
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
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 ... https://www.youtube.com/watch?v=pjxVAkPysCw
3729128 Bytes