|
jyms
|
09-26-2009, 05:38 AM
Post subject: microsoft Excel
|
#1 (permalink)
|
|
Tilting Mod
Join Date: Feb 2006
Posts: 4,836
|
|
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.
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
UG
|
|
Moderator
Join Date: Jan 2005
Posts: 1,855
|
|
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.
|
|
|
|
Stacks
|
|
4-of-a-Kind
Join Date: Jan 2008
Location: Im opedipus bitch, the original balla.
Posts: 2,605
|
|
Help?
|
|
|
|
Stacks
|
|
4-of-a-Kind
Join Date: Jan 2008
Location: Im opedipus bitch, the original balla.
Posts: 2,605
|
|
Yep.. nomnomnom... Just tried it and worked great. Haz fun.
|
|
|
|
jyms
|
|
Tilting Mod
Join Date: Feb 2006
Posts: 4,836
|
|
Thanks guys, I knew the answer would come quicker here than reading through tons of help pages.
|
|
|
|
jyms
|
|
Tilting Mod
Join Date: Feb 2006
Posts: 4,836
|
|
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.
|
|
|
|
EasyT
|
|
Full House
Join Date: Jan 2005
Location: Yo Mamma
Posts: 834
|
|
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.
|
|
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
