OK, it is as follows:
1. type January in cell a1.
2. select cells a1 to a12 by pressing down arrow along with shift key or by
typing the range value "a1:a12" in the go to dialog which can be obtained by
pressing f5.
3. after selecting the cells, go to edit menu by pressing alt + e.
4. go to fill submenu by pressing I.
5. choose series option by pressing S. the series dialog appears.
6. choose autofill radio button by pressing alt + F.
press enter on OK button and you are done.
Umesha
----- Original Message -----
From: "krishan" <[email protected]>
To: <[email protected]>
Sent: Monday, 27 February, 2012 9:37 AM
Subject: Re: [AI] Ms Excel Help Auto Fill
respected sir ineed step by step titorial excel 2003:
On 2/27/12, Umesha Economics <[email protected]> wrote:
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
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
