From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Creating text, numerical, date, and time lists in a flash

Creating text, numerical, date, and time lists in a flash - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Creating text, numerical, date, and time lists in a flash

- 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…

Contents