Re: [AI] Ms Excel Help Auto Fill
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 k.thakur...@gmail.com To: accessindia@accessindia.org.in 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 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 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
Re: [AI] Ms Excel Help Auto Fill
Hello Zoher, I thank you very much for guiding me. I also thank all list members who took time out to reply to this request. With Regards, Pavan Manager- Delivery Channels, Corporation Bank, HO Mangalore-1 Ph: 9886496908 On 2/27/12, zoher zos...@gmail.com wrote: no! when you enter on seareez button, go back by pressing shift + tab there you will hear leanior radio button checked then use your up and down arrow keys to go to auto fill option and date option. - Original Message - From: Mujtaba Merchant mujta...@gmail.com To: Access India accessindia@accessindia.org.in Sent: Monday, February 27, 2012 12:00 PM Subject: Re: [AI] Ms Excel Help Auto Fill Hello Umesha and Zoher, That did the trick really well. But the flaw here is when I tried to do this myself using the tab key on the fill series dialog box it skipped the option of Auto Fill. Which is of some great concern. Pressing ALT F gets me to this option. Switched over to the JAWS cursor and was then able to see where this option is in the dialog box. Thank you for the value add! 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
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
Re: [AI] Ms Excel Help Auto Fill
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
Re: [AI] Ms Excel Help Auto Fill
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
Re: [AI] Ms Excel Help Auto Fill
Hello Umesha and Zoher, That did the trick really well. But the flaw here is when I tried to do this myself using the tab key on the fill series dialog box it skipped the option of Auto Fill. Which is of some great concern. Pressing ALT F gets me to this option. Switched over to the JAWS cursor and was then able to see where this option is in the dialog box. Thank you for the value add! 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
Re: [AI] Ms Excel Help Auto Fill
no! when you enter on seareez button, go back by pressing shift + tab there you will hear leanior radio button checked then use your up and down arrow keys to go to auto fill option and date option. - Original Message - From: Mujtaba Merchant mujta...@gmail.com To: Access India accessindia@accessindia.org.in Sent: Monday, February 27, 2012 12:00 PM Subject: Re: [AI] Ms Excel Help Auto Fill Hello Umesha and Zoher, That did the trick really well. But the flaw here is when I tried to do this myself using the tab key on the fill series dialog box it skipped the option of Auto Fill. Which is of some great concern. Pressing ALT F gets me to this option. Switched over to the JAWS cursor and was then able to see where this option is in the dialog box. Thank you for the value add! 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