sorry for I forgot to tell you that my previous post to the thread applies
to excel 2003 only. I don't know about excel 7 or excel 10.
dear Merchant,
the procedure is almost the same as you said for filling the months like
january, February, etc. or weeks like Sunday, Monday, etc. as in your
previous procedure, instead of typing 1 in cell A1, type "january" or
Sunday" which ever you want. in the series dialog box, press alt+F to select
the autofill radio button and hit enter on OK button. that's all. you can do
it for any list of words other than months and weeks if you add them to your
custom lists in excel.
Umesha
----- Original Message -----
From: "Mujtaba Merchant" <[email protected]>
To: <[email protected]>; "Access India" <[email protected]>
Sent: Sunday, 26 February, 2012 11:06 PM
Subject: Re: [AI] Ms Excel Help Auto Fill
Hello Pavan,
I can help you with the auto fill of a series of numbers, somehow I fail
to do the same with weeks or months, not sure why because the logic is the
same...
Anyway, here is the Auto Fill for a series of numbers.
In cell A1 type the number 1.
Stay focused on A1 and use the shift key and the down arrow to select
cells till A12
Then press these keys to bring up the autofill dialog box without
disturbing your selection.
Alt,E,I,S
This should bring up the series dialog box. Let the step value be 1. Tab
to the stop value and type in `12. Tab to the OK button and press enter.
If you have done everything as expected, you now should have cells from A1
to A12 filled with numbers from 1 to 12.
Here is how to do the same with virtual ribbons on in JAWS 12 or 13.
Follow the same steps to select the auto fill range.
Use the alt key to get to the Home tab in the ribbon.
Down arrow to Editing Submenu. Enter or Space bar on Fill button drop
down. Down arrow and hit enter on series...
Follow the same steps to define your step and stop value and complete the
auto fill function.
Other list members kindly teach us on how to auto fill months and weeks
please.
Mujtaba Merchant
Bangalore, India
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
