respected sir ineed step by step titorial excel 2003: On 2/27/12, Umesha Economics <umesha....@gmail.com> 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" <mujta...@gmail.com> > To: <pavansm...@gmail.com>; "Access India" <accessindia@accessindia.org.in> > 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/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> 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/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > 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/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in 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