Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
For some users they enter the current date throughout the course of a day frequently, and some users even the current time. You could enter this information very quickly with a couple of great keystroke shortcuts. Suppose we want to put the current date in cell B2. As I am recording this in mid-July of 2010, Ctrl+; that's the current date. That's it. This is also handy if you want to put in, say in a different cell, a nearby date. Maybe you want to put in the 21st or the 28th or something like that. Ctrl+; and since I am still editing here change the 0 to 8 and do that, makes it fast.
Current time, the keystroke shortcut Ctrl+Shift+;. This will be the standard display. You can certainly change that. Depending on whether you might have had a date in here previously you might see this kind of a display, and so a simple right-click and Format Cells and a time entry, something like this perhaps, either this variation or the one that shows AM/PM. In both cases here, what you are doing is saving typing. You're not putting in any kind of datat that's going to be dynamic, that's going to change.
It will not change unless you actually change the content of the cell. Some people actually will put this into a worksheet just before they print it because it is accurate at the moment. But it's fast, it's easy, and it saves you a good deal of typing here and there. Particularly with the date, because I think a lot of people will use this frequently.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 75246 Viewers
80 Video lessons · 130075 Viewers
52 Video lessons · 64209 Viewers
59 Video lessons · 50016 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.