answersLogoWhite

0

Hold down the Ctrl key and press they key with the ; on it. If you do the same while also holding the shift key down, you will get the current time. If you enter the formula below into a cell it will put in the current date:

=TODAY()

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Which key do you press to enter the current date in a cell?

Hold down the Ctrl key and press they key with the ; on it. If you do the same while also holding the shift key down, you will get the current time.Ctrl+;


What is the shortcut to enter the date in Excel?

The formula is =NOW(). Ensure you format the cell to display the date format you want.


What to insert the current time into a document click the insert date and time button?

Insert.


What is the keyboard shortcut to know the current date?

Alt + 6 +j +@


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 the mortgage origination date for your current home loan?

The mortgage origination date for my current home loan is insert date.


What key do use to insert current time in a worksheet cell?

Ctrl - shift and the colon key. So it would be Ctrl - Shift - : Without the Shift it will give you the current date.


What does today mean in Excel?

The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.


What displays the current date on each page of an Excel worksheet use the function?

In a cell you can put:=Today()If you are talking about on printed pages, there are options to insert the date into the header and/or footer areas if you go into Page Setup before printing.


What code does Excel insert when you click the Current Date button in the Header and Footer Tools Design tab?

It puts in: &[Date]


Insert date on a webpage using javascript?

Just use new Date(); to get the current date and then use document.getElementById to insert it on the webpage. <div id="example"></div> <script type="text/javascript"> document.getElementById('example') = new Date(); </script>


How do you display the current-date in a Wordpad document in any particular format?

Pick Insert, and then Date and you could choose from a list of formats.