answersLogoWhite

0


Best Answer

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+;

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Which key do you press to enter the current date in a cell?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Natural Sciences

How do you change the clock on an HP Officejet 5510 All-In-One?

Install the HP Director software... http://h10025.www1.hp.com/ewfrf/wc/softwareCategory?product=311255&lc=en&cc=us&dlc=en?=en&cc=us Normally the computer software sets the date and time automatically. http://h10032.www1.hp.com/ctg/Manual/bpu72474.pdf page 50-51 set the date and time You can set the date and time from the front panel. When a fax is transmitted, the current date and time are printed along with the fax header. The date and time format is based upon the language and country/region setting. Normally the computer software sets the date and time automatically. Note: If your HP Officejet loses power for more than 72 hours, you will need to reset the date and time. 1 Press Setup. 2 Press 3, then press 1. This selects Basic Fax Setup and then selects Date and Time. 3 Enter the month, day, and year (last two digits only) by pressing the appropriate number on the keypad. Depending on your country/region setting, you might enter the date in a different order. The underline cursor presented initially beneath the first digit advances automatically to each digit each time you press a button. The time prompt automatically appears after you enter the last digit of the date. 4 Enter the hours and minutes. The AM/PM prompt automatically appears after the last digit of the time is entered if your time is displayed in the 12-hour format. 5 If prompted, press 1 for AM or 2 for PM. The new date and time settings appear on the front panel. reference guide use the fax features 51 fax set the paper size You can select the paper size for received faxes. The paper size selected should match what is loaded in your input tray. Faxes can be printed on letter, A4, or legal paper only. Note: If an incorrect paper size is loaded in the input tray when a fax is received, the fax will not print. Load letter, A4, or legal paper, and then press OK to print the fax. 1 Press Setup. 2 Press 3, then press 5. This selects Basic Fax Setup and then Fax Paper Size. 3 Press to highlight an option, and then press OK.


How do you change date and time on Sharp EL-1801V calculator?

To change the date, set the tab on the the top to "rate set" enter the date in MM.DD.YY format, pressing the decimal key between the month and day (will show as a decimal on the display) and the day and year (will show as a dash on the display). Then, press the Time/Date key (the one that looks like a clock and a calendar). The new date will show on the display. Note that if the month is less than 10, you do need to press the 0 (zero) key for the first digit, even though it will not show on the display. To change the time, enter the time in 24-hour HH.MM format, pressing the decimal key between the hour and minute. Then, press the Time/Date key. The new time will show on the display. Note that if the hour is less than 10, you do need to press the 0 (zero) key for the first digit, even though it will not show on the display. When you are finished be sure the set the tab back to the "•" which is the neutral position.


What are the two basic types of data you can enter into a cell?

Spreadsheets generally accept two fundamental types of data: constant data, such as a constant number, date, time or text, or formulas. Formulas produce data of the same data types (e.g. text, number, date, time, etc), but are evaluated dynamically.


Where can one find the latest news on blood stem cells?

There are many websites detailing current news regarding blood stem cell research. The Cord Blood Registry website has a section dedicated to the latest stem cell news. Science Daily and Medical News Today are also good sources of up-to-date news in this field.


What job does a fat cell do?

Stores fat for energy for an organism to use at a later date.

Related questions

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 do you press to enter the current data in Excel?

To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.To enter the current data, press the Enter key when have typed what you want, or click on the tick beside the formula bar. If you mean the current date, then press and hold the Ctrl key and press the semi-colon key.


What is the shortcut key to insert 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. If you enter the formula below into a cell it will put in the current date: =TODAY()


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.


Which symbol may be used in an Excel formula to display current date?

The TODAY() function displays the current date. If you want to put the current date into a cell, press the Ctrl and the semi-colon key.


What formula is typed in a cell to display the current date?

You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.You can type:=TODAY()This is will always have the current date in it, so it will change each day. You can also press and hold the Ctrl key and press the ; key to enter today's date, but the date will not have changed to a new date if you open it on another day. The NOW() function works like TODAY() but gives the time as well as the date.


How do you get dates in Excel?

You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)You can just type them in. You can enter the TODAY() function to show the current date. You can press Ctrl and the colon key to get the current date. You can use the NOW() function to get the current date and time. You can use the DATE() function to create a date base on numbers for the year, month and day. So to get the 2nd of December 2005 you could do this:=DATE(2005,12,2)


How does Excel automatically enter today's date?

If you press the Ctrl key and the ; key, it will put in today's date. If you use the Today() function, it will always show the current date when a spreadsheet is opened. So in a cell you just have to put: =Today() Then no matter when you open the file it will always have the date of the current day in that cell.


Which function will you use to enter current date and time in a excel worksheet cell?

The TODAY function can enter today's date in Excel. The DATE function can be used to build a date from the day, month and year elements.


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()


What keystroke combination will enter the current date into the active cell?

I assume that you are talking about Excel.Shortcut: Ctrl + ; (semi-colon)You can make the current date appear into the active cell by typing a function in it that was designed specifically to do just that.The function is as follows:=TODAY()If instead of the current date, something weird shows up, you might have to format the cell. Right click the cell, click 'Format cells', choose 'Date' as the category and choose your favorite format.


How do you set time on a Sonata 7982PP02 watch?

First press the mode button three time and enter the second using the date button and press alarm button and enter the minute again press the alarm button and enter the hour and press alarm and set the date and