Never mind my last email, I got it. I had to widen the columns. I felt stupid after writing that last message.
What I am trying to do which is why I poked my head in this thread to begin with is do a time sheet for work but not have to manually type the dang date each day which isn’t hard when I can just hit CTRL semicolon. But, now I need to figure out how to have it ignore the weekend, which I think I just need to set it to week days. Lets try that. From: Dale Alton [mailto:[email protected]] Sent: Sunday, January 3, 2016 3:46 PM To: [email protected] Subject: Re: Creating column of dates in Word 2013 Don't change the step value. Let it remain at 1 in step 6. Denver Dale From: Kimsan [mailto:[email protected]] Sent: Sunday, January 03, 2016 3:27 PM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 I will try it again, but I will write as I am doing it. 1. Launch excel 2. For A1, through a4, I will put ¼, 1/5, 1/6 and 1/7. 3. I will select A1 through a4 and evoke the keytip alt h f I s. 4. I am in the series dialog, so let me review what is selected in the radio buttons. 5. Collumns, date and day. 6. Where I thought it said start value, it actually says step value. I have terrible hearing, sorry. I put 1/4 there and put no stop value.. The trend checkbox is unchecked and I tab to ok and press spacebar. Now, you would think in a5, it should say 1/8 right? It doesn’t say nothing. From: Dale Alton [mailto:[email protected]] Sent: Sunday, January 3, 2016 2:10 PM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 I used your example and put 1/4then selected the cells. Denver Dale From: Kimsan [mailto:[email protected]] Sent: Sunday, January 03, 2016 1:43 PM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 What do you put for the start value. From: Dale Alton [mailto:[email protected]] Sent: Sunday, January 3, 2016 5:46 AM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 The only thing I don't do is put in an endvalue. I select the columns or rows that I need to get the desired effect and then run the fill, i.e. a1:a31 or a1:ae31. hth Denver Dale From: Kimsan [mailto:[email protected]] Sent: Saturday, January 02, 2016 9:08 PM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 I tried that last night putting ¼ in A1, 1/5 in a2, and finished at a4. Then I selected the rows with the dates I just wrote, did alt h f I s and it put me in the start value, which I put 1 to increase by 1 day, then the stop value, I put 30, for 30 days. Nothing happened. Did I do it wrong? Or something wrong? From: Dale Alton [mailto:[email protected]] Sent: Thursday, December 31, 2015 8:55 PM To: [email protected] <mailto:[email protected]> Subject: Re: Creating column of dates in Word 2013 Hi, This is how I would do it. Start 3 in a row for example 1/1/201, 1/8/2016, and 1/15/2016. Then highlight the number of rows or columns that you want the series to go on. For example a1:a52. Once that is done do an alt+h, f, I, s. This will put you into the fill area and into series. When I tested it the information was already there for every 7 days and I tabbed down to ok. I hope this helps. Denver Dale From: Mike B. [mailto:[email protected]] Sent: Thursday, December 31, 2015 2:55 PM To: [email protected] <mailto:[email protected]> Subject: Creating column of dates in Word 2013 Hi All, Posting this for someone else hoping someone can help him: From: Danney Yates <mailto:[email protected]> Trying to create a running column of dates edit; typed in Friday January 1, 2016 and hit enter, hoping that Word would just insert the next date, etc but it will not. I've searched menus and cannot locate a way to do this. Isn't this possible, rather than my having to type all these dates manually? Thanks for any help ! Danney Yates
