Need to enter today's date or time in your data? Learn simple keystroke shortcuts for doing just that.
- [Instructor] In the Chapter 2 file,…the second worksheet is called Instant Date/Time Entry.…And anytime you need to type today's date,…and some people do this a lot during the course of the day.…Don't do it anymore.…Simply press Ctrl + ;…And at the time of this recording,…it's May 8th of 2017.…And by the way, sometimes you'll see this…in notes or in a help system.…It might be displayed the way we see it here in cell A2,…Ctrl plus that actual symbol.…Sometimes you'll see it displayed this way.…Of course that means the same thing.…Ctrl + ;…Like a lot of keystroke shortcuts,…you would never know or guess that.…
This is not putting in a formula.…It's just a shortcut for typing.…Sometimes I'll use this…even though I want to put in a different date,…but it might be a nearby date.…If I want to put in May 3rd, for example,…I might press Ctrl + ;…I'm in edit mode.…I'll slide across the eight, put in a three, and enter.…That possibly is faster than typing it.…Occasionally you might want to enter the current time.…I'll click in cell E2 and press Ctrl + Shift + ;…
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.