microsoft Excel

Anybody know how to put a date, for say the next month or two, into a bunch of cells? Say I want each cell to have a consecutive date running down the page, is there some kind of auto fill for this. I can do a ton of stuff in excel, but this has stumped me. I hate having to change the dates and retyping each one individually.

copy whatever date it is, hold CTRL and click on all of the cells you want filled and paste? sucks to click every cell but it's better than typing it in one-by-one.

Help?

Yep.. nomnomnom... Just tried it and worked great. Haz fun.

Thanks guys, I knew the answer would come quicker here than reading through tons of help pages.

Quote:

---

Originally Posted by UG

copy whatever date it is, hold CTRL and click on all of the cells you want filled and paste? sucks to click every cell but it's better than typing it in one-by-one.

---

This seemed to paste the same date all the way down. What I did find out through Stacks link was to ctrl/right click the bottom corner and drag the box down as many cells as needed and a fill box will pop up, I can do weekly, monthly or yearly fills in the boxes, cool.

Fill in the first 3 dates. Highlight the 3 cells. Grab and hold the little square that appears on the lowest right-hand corner and drag that all the way down. Lemon Squeezey.

Excel master in da hizouse. Available for any helps needed.