![]() Simply enter the following formula in a cell whenever you need to insert current date in excel: =today() using this function, we can easily find out the current date, day of the month, or the current month of the year. the inset today's date as an unchangeable timestamp that won't automatically update the next day, use one of the following keyboard shortcuts: to inset today's date: ctrl to insert the current time: ctrl shift to enter the current date and time: ctrl then space and then ctrl shift. download 200 excel shortcuts get over 200 excel shortcuts for windows and mac in one handy pdf. In this video we look at several options to enter a current date and time in a worksheet. if you want the current time, type control shift. A handy addition to our favourite excel keyboard shortcuts: typing control will insert the current date. please send us your comments on this article. press ctrl (semicolon) to enter today's date. select the cell in which you want to enter today's date. this is how to insert today's date using the shortcut keys.
0 Comments
Leave a Reply. |