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

14y 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 command can automatically insert the current date and time into a document in variety of formats is the?

In Microsoft Word, you can automatically insert the current date and time using the command "Insert > Date & Time." This command allows you to choose from various formats for displaying the date and time. You can also use the shortcut Alt + Shift + D to quickly insert the current date and Alt + Shift + T for the current time. In Google Docs, you can use the "Insert > Date" option to add the current date.


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 is the keyboard shortcut to know the current date?

Alt + 6 +j +@


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

Insert.


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

The mortgage origination date for my current home loan is insert 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]


How do you add date in a worksheet?

To add a date in a worksheet, you can simply click on the cell where you want the date to appear and type the date in the desired format (e.g., MM/DD/YYYY or DD/MM/YYYY). Alternatively, you can use a formula like =TODAY() to insert the current date, which will update automatically each day. After entering the date, you can format the cell to change its appearance by right-clicking and selecting "Format Cells."