0
The formula is =NOW(). Ensure you format the cell to display the date format you want.
Wiki User
∙ 13y ago
Wiki User
∙ 8y agoPress and hold the Ctrl key and then press the ; key. That will put in the current date.
Add your answer:
Earn +20 pts
What is the shortcut to paste values only in excel?
ALT-e-s-v followed by ENTER
When you enter a date Excel assigns a?
a serial value to the date
When you enter a date excel assigns a what value to the date?
numerical
How do you make a keyboard shortcut to enter the current date into cell B4 of the Pasadena worksheet in Excel?
There already is a shortcut to do that. Press and hold the Ctrl key and press the semi-colon key. That date won't change if you save it and open the worksheet on another day. If you need the date to be the current date on whatever day you open it, then use the TODAY() function, or else press Ctrl and the colon key every day.
What is text alignment shortcut key justified?
Excel does not have any shortcut keys for aligning text. See related links for all shortcut keys for Excel 2007.
What is an excel function used to enter the system date in a cell in a worksheet?
The NOW function
What is the keyboard shortcut for the Auto-Sum feature on excel is?
Alt+=
What are the steps to start Microsoft excel?
Create a shortcut key by right clicking on the excel icon on the desktop or from the folder menu and click properties. Define your shortcut key. Can do from the keyboard once this is done.
What is the right click menu in excel called?
It is called the shortcut menu.
What does the now in Excel mean?
The NOW function puts in the current date and time into a cell. You enter it like this: =NOW()
How do you make cells change color automatically depending on what date is entered in 2007 excel?
Use conditional formatting to set the condition when you enter a particular date.
What keyboard shortcut is the help resource in Excel 2012?
F1 is always help in Excel and other Windows products. It is a universal standard.
