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 The Author of this article: Ashish is one of the co-author of this blog and writes on various interesting softwares, PC tips and more. You can read more of his articles here.

Readers Play Ground

• Add your Comments or Discuss further in our forums

• Enjoyed this article? Subscribe to the Full RSS Feed

• Click to save on your favorite Social Bookmark Site del.icio.us Digg it Furl Netvouz Spurl Yahoo MyWeb Google DZone StumbleUpon
• (No Ratings Yet)
  
   Loading ...
• Email This Post to your friends or somebody who can use it
• Tags: date formats, excel tips, microsoft office 2007, office excel, Office Tips, office-2007-tips
  
• Get Post like this in your Inbox Click to get via Email ( You will have to confirm by checking you Inbox)
• Read More Stories from Office Tips