you should upload somewhare eles like sendspace or dropbox. because the atachments are not aloud in this mailing list. so it is not showing here.
On 5/19/12, Zujar Shabbir Kanchwala <[email protected]> wrote: > Hi AccessIndians, > > I have sent the reference document to all who requested it for. Check your > inbox and let me know if I missed serving your request. > > Shoot me your response on [email protected] and not the list. > > Best Regards, > Zujar > > An optimist laughs to forget while a pessimist forgets to laugh... > > > -----Original Message----- > From: Zujar Shabbir Kanchwala [mailto:[email protected]] > Sent: Tuesday, May 15, 2012 9:53 PM > To: '[email protected]' > Subject: RE: [AI] How to use data validation and filtering options in > Excel2007 file > > Hi Surinder, > > I have sent you an email with notes that I had prepared for sighted > students > a few years ago offlist as attachments are not allowed here. > > Please write to me offlist if other AccessIndians wish to refer this > document. I'll respond to all requests on Saturday 19th May. > > Best Regards, > Zujar > > An optimist laughs to forget while a pessimist forgets to laugh... > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Surinder > Sent: Tuesday, May 15, 2012 5:13 AM > To: [email protected] > Subject: Re: [AI] How to use data validation and filtering options in > Excel2007 file > > Hi Zujar, > > I think you have mastered Excel. Do you have tutorials on use of excel with > > Jaws? > I need a comprehensive tutorial, not one which is available on Stacy > Bleek's > > website. > > Thanks > > ----- Original Message ----- > From: "Zujar Shabbir Kanchwala" <[email protected]> > To: <[email protected]> > Sent: Monday, May 14, 2012 6:58 PM > Subject: Re: [AI] How to use data validation and filtering options in > Excel2007 file > > >> About Data Validation: >> >> It helps you validate data at the time of input. Suppose you have a >> column >> that records that Rate of a product and the minimum rate is 50 and >> maximum >> is 200. You can discard all inputs that are non numeric or numeric values >> below 50 and above 200 as follows. >> >> 1. Select the cells that you want to validate data entry. >> 2. Click Data menu and select Validation from the menu. Alternatively >> ALT+D >> followed by L. The Data Validation dialog opens with Settings tab by >> default. >> 3. Specify the below values in the dialog box: >> Allow: Whole Number >> Data: Between >> Minimum: 50 >> Maximum: 200 >> 4. Activate the OK button. >> 5. Now when your cursor is on one of the selected cells, JAWS would >> indicate >> that is it a whole number input between 50 and 200. Try entering an >> invalid >> value in it and see how Microsoft Excel behaves. >> >> You can check out the other options to restrict input in a cell by >> exploring >> various options in the Allow combo box. You can select List in this combo >> box and specify the list of items in the Source edit box. For example to >> specify months: >> >> 1. Select List in the Allow combo box. >> 2. Specify comma separated list of months in the Source edit box as shown >> below: >> >> January, February, March, April >> >> The cells would contain a combo box with the list of specified items. >> >> About Data Filtering: >> >> Data Filtering helps you hide irrelevant data from the current view. This >> >> is >> useful when you have a large amount of data and want to view data that >> meets >> specific criteria. Microsoft Excel provides two options for filtering: >> >> AutoFilter - This option places a combo box on top of each column with >> values in that column. Selecting a specific value in this combo box hides >> rows that do not match the selected value in that column. In other words, >> uncheck values that you wish to hide from the current view. You can apply >> AutoFilter by selecting Data menu > Filter > AutoFilter. Alternatively, >> ALT+D followed by F F. >> Advanced Filter - This option comes to play when you have a complex >> criteria >> like all products costing 500 and above with a total sales volume of >> 3000000 >> and above. Select Data menu > Filter > Advanced Filter or press ALT+D >> followed by F A. The Advanced Filter dialog box asks for the following >> options: >> >> List Range: This is the source data to filter For example, $A$1:$P$201. >> Criteria Range: This specifies the range of cells where you have entered >> the >> filter criteria. For example $q$1:$r$2. >> >> Here are the steps to apply an advanced filter to list all products that >> cost 500 or more with a sales volume of 3000000 and above. >> >> 1. Select the list range for example, $A$1:$J$1000. >> 2. Place the cursor in any cell other than the above range. I choose K1 >> for >> now. Enter values in cells as shown below: >> K1 Cost >> K2 >=500 >> L1 Sales >> L2 >=3000000 >> >> 3. Select Data menu > Filter > Advanced Filter. Alternatively, ALT+D >> followed by F A. >> 4. Specify the following list and criteria ranges in the Advanced Filter >> dialog box: >> List Range $1$1:$J$1000 >> Criteria Range $K$1:$L$2 >> >> 5. Activate the OK button. >> >> Your data would display only records that match the criteria specified in >> the cell range K1:L2. If you change any criteria then you need to apply >> the >> filter once again. The data would not auto refresh. >> >> About password protecting and sending a file through email: >> >> You can apply a password in the Save As dialog box as outlined below: >> >> 1. Open the File that needs be password protected. >> 2. Open the Save As dialog box. This dialog box opens when you save a new >> file or select Save As from the File menu. >> 3. Press ALT+L to open the Tools menu within the dialog box and select >> General Options from the menu. >> 4. Specify the password to open or password to modify or both in the >> resulting dialog box and activate the OK button. Note that you need to >> type >> any password twice in the dialog box for ensuring correct entry. >> >> You can send the file as an attachment to an email. Select File > Send > >> Email. A blank email opens in the configured email client with the file >> listed in attachments and Subject/Body prepopulated. You can edit these >> files and send the email to the desired recipients. >> >> Note that I have specified classic menu shortcuts to keep things simple. >> Let >> me know if you need more inputs. >> >> Best Regards, >> Zujar >> >> An optimist laughs to forget while a pessimist forgets to laugh... >> >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of tiku raj >> Sent: Sunday, May 13, 2012 1:52 PM >> To: accessindia >> Subject: [AI] How to use data validation and filtering options in Excel >> 2007 >> file >> >> Hello friends, >> >> Good afternoon. hope all are fine. >> >> 1. I would like to know how to use data validation and filtering >> options in Excel 2007 file. >> >> 2. How to send Excel 2007 file with password protection through mail. >> >> Please write step by step to understand this functions. >> >> With regards, >> >> Tiku >> >> >> 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 > > 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
