Join Dennis Taylor for an in-depth discussion in this video Creating text, numerical, date, and time lists in a flash, part of Excel Tips Weekly.
- The right mouse button is a valuable tool in Excel.…it allows us to get to a shortcut menu.…But we can also drag with the right mouse button,…sometimes referred to as a right drag.…It allows us to fill in data pretty quickly…by way of a menu.…So it still, you could say, adheres to the definition of…the right mouse button always means shortcut menu.…In this worksheet in column A here,…we're about to put in some sales numbers here.…And we want to set up for the year a mid-month report.…In other words, the 15th of every month.…
Now we could be using any day we want here,…but we're using the 15th,…and we'd like to fill this in for the remainder of the year.…So, instead of putting in February 15th just below this,…highlighting both and dragging, we can certainly do that,…why not type nothing, but instead…use the right mouse button here.…On the fill handle I'm holding down the right mouse button,…dragging down here to about row 13,…releasing the right mouse button…and then the menu appears Fill Months.…In other words these are all a month apart…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.