but the subject should have been changed to 'creating columns in excel'
Legend has it that on Sunday 1/3/2016 06:33 PM, Dale Alton said:
----------------------------------------
Yea!!!!! Happy to hear success.
Denver Dale
From: Kimsan [mailto:[email protected]]
Sent: Sunday, January 03, 2016 5:25 PM
To: [email protected]
Subject: Re: Creating column of dates in Word 2013. Ok, got it!
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]>mailto:[email protected]]
Sent: Sunday, January 03, 2016 3:27 PM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Sunday, January 3, 2016 2:10 PM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Sunday, January 03, 2016 1:43 PM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Sunday, January 3, 2016 5:46 AM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Saturday, January 02, 2016 9:08 PM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Thursday, December 31, 2015 8:55 PM
To: <mailto:[email protected]>[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]>mailto:[email protected]]
Sent: Thursday, December 31, 2015 2:55 PM
To: <mailto:[email protected]>[email protected]
Subject: Creating column of dates in Word 2013
Hi All,
Posting this for someone else hoping someone can help him:
From: <mailto:[email protected]>Danney Yates
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
----------------------------------------
<http://www.sendspace.com/folder/i7xwg4>Click
here to check out my sendspace offerings!
-=-=-=-=-=-=-=-=-=-=-=-
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
JFW List instructions:
To post a message to the list, send it to [email protected]
To unsubscribe from this mailing list, send a message to
[email protected]
Archives located at: http://www.groups.io/g/jfw/threads
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, posts received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at [email protected].
-=-=-
Groups.io Links:
You receive all messages sent to this group.
View This Message (#36225): https://groups.io/g/jfw/message/36225
Mute This Thread: https://groups.io/mt/362489?uid=21656
Change Your Subscription: https://groups.io/g/jfw/editsub?uid=21656
Unsubscribe: https://groups.io/g/jfw/leave/46502/1292106160/xyzzy
Group Home: https://groups.io/g/jfw
Contact Group Owner: [email protected]
Terms of Service: https://groups.io/static/tos
-=-=-=-=-=-=-=-=-=-=-=-
