Home » Tips N Tricks » Office Tips » How to auto generate months in Microsoft Office Excel 2007

How to auto generate months in Microsoft Office Excel 2007

I was preparing my accounts for this financial year and had to do calculations month by month. Now it was really tiring to type each month one by one. I wanted to generate all the months automatically and I found how to do it. Damn Easy Here are the steps.

  • Select a cell in excel , right click and select the type as Date.
  • In Date you will get various options like Date formats in MM.DD.YY and more. Select Just M i.e which means months.
  • Now keeping the cell selected, you should be able to see a cross mark at right corner.
  • Grab it with your mouse and start dragging down.
  • As you drag down, You will see Excel showing you next month . Look at the picture for better understanding.

Want to read more tip ? There you go 9 Tips to increase your productivity with Excel 2007 [ Office ]

Note #1 : Since I already typed in April, it started generating from April and it rolls on January again when you cross December.

Note #2 : This should be applicable to many things like auto increment numbers 1,2,3 or incrementing dates. Give it a try.

Hope that helps many of you. Happy Accounting.

About Ashish Mohta

A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. His expertise are in Windows 7, Microsoft Office, Software, Mobile Apps and Video Posts.