Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel and other Microsoft topics.

How can I automatically enter the months?

Automatically Enter the Months

To enter the months from January to December, type January and position the cursor over the right hand bottom corner of the active cell. The cursor should change into a cross, drag the cross down/across will automatically enter the rest of the months in the cells below/side.

Comments

Nobody has commented on this tip yet. Be the first.

Ask a Question

Not finding the advice and tips you need on this Microsoft Tip Site? Request a Tip Now!

Guru Spotlight

Ray Lokar

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!