- Insert the current date and time in a cell - Microsoft Support
On a worksheet, select the cell into which you want to insert the current date or time Do one of the following: To insert the current date, press Ctrl+; (semi-colon) To insert the current time, press Ctrl+Shift+; (semi-colon) To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi
- How to Insert Todays Date in Microsoft Excel - How-To Geek
To insert today's date as a static value in your spreadsheet, first, open your spreadsheet with Microsoft Excel In the spreadsheet, click the cell in which you want to display today's date While the cell is selected, press Ctrl+; (semicolon) to add today's date in the cell This keyboard shortcut works on both Windows and Mac
- How to Insert Date in Excel? (Shortcut + Formulas) - Spreadsheet Planet
On your keyboard, press Ctrl + ; (hold the Control key and then press the semi-colon key) Press Enter, and the current date will be inserted as shown Note the DD MM YYYY format picked up by Excel from the system’s settings Yours may be different Also, the date entered using this method is static
|