Wednesday, January 5, 2011

EXCEL: Column Headings, Auto Input

Here's the fastest way to auto-fill those column headings like January, February, March...

  • Type JAN or January in the first cell
  • Select that first cell and position your cursor in the lower right corner of that cell, so your cursor turns into a solid black crosshairs (or plus sign +), hold down your left mouse button and drag to the right
The months will automatically fill the rest of the months, so you will see something like this.  (This also works for Mon, Tue, Wed & other common sequences):

JAN FEB MAR APR MAY JUN JUL


















No comments:

Post a Comment