Hai dear Mailing list members I have doubt in excel What is V lookup?,what is the use of it?, and Can we creat chart in excel what is the use of it? Can anyone clear my doubt
Thanks Regards Selvakumar On 7/9/14, Mahesh Narasimhan <[email protected]> wrote: > Hi Kavita and all the list members, > > I just tried the Filter and you try the following. You might like it. > > Step 1: Make a table. > Step 2: Sort it by selecting the table. > Step 3: Go to the column head which you want to filter. > Step 4: Press Alt+A to go to the "Data Menu", then press down arrow to > activate it. > Step 5: Press Tab till you reach Filter Submenu; here you press right > arrow ones and then press Tab till you reach custom filter. Here > please press the Enter key. Then type the value that you want and > press Tab till Ok and press Enter on Ok. > > Hope this works. > > Cheers! > > -- > Good friendship is like the relationship between eye & hand! If the > hand is hurt, the eye will cry! & when the eye cries, the hand will > wipe the tears!!! > With best regards, > Mahesh Narasimhan > M: +91(0)9899353960 > E: [email protected] > > > > On 7/9/14, Neha Agarwal <[email protected]> wrote: >> Hello >> No worries, its an individual choice. >> Long method was shared as requested step by step guidance >> Cheers >> Neha >> >> Sent from my iPhone >> >>> On 07-Jul-2014, at 15:57, echo glad <[email protected]> wrote: >>> >>> thankyou so very much... got to learn a new thing in the simplest way >>> instructed by Zoher Kheriwala... sorry didn't try the other methods by >>> neha and arvind... the very first proved so much short cut... (as i >>> like short cuts while working in the shortest time periods/durations) >>> >>>> On 7/6/14, Aravind R <[email protected]> wrote: >>>> shortest step is going to the header of the column and pressing >>>> ctrl+shift+l then pressing alt+down arrow. >>>> >>>>> On 7/5/14, Neha Agarwal <[email protected]> wrote: >>>>> Hi Kavitha, >>>>> >>>>> Find the steps below. >>>>> 1. Focus on the header row and press alt key to open the menus. >>>>> 2. Press right arrow key till you reach data menu/tab. >>>>> 3. press down arrow key to open the data menu/tab. >>>>> 4. In the sort and filter sub menue you will find the option of >>>>> filters, hit enter on it. >>>>> 5. Now you are in your work area of the sheet. Go to the contacts >>>>> column. You will find a dropdown menu, press alt+down arrow key to >>>>> open the dropdown menue. >>>>> 6. Press down arrow key till you reach the check boxes anouncing your >>>>> yes/no/reject/blanks. >>>>> 7. you have 2 ways to get the data here. >>>>> 1st, there will be the check box called 'all' by hitting space bar on >>>>> it uncheck that and press down arrow key till you hear 'yes unchecked' >>>>> hit space bar on it then press tab and hit enter on the ok button. You >>>>> are done with the filtered data as desired. >>>>> 2nd, Keep 'all' option checked and press down arrow key and uncheck >>>>> the 'no'/ 'reject' / 'blank'by hitting space bar on it then tab hit >>>>> enter on ok button. You are done . >>>>> 8. Press down arrow key and see the results as desired. >>>>> Hope this helps. >>>>> >>>>> Cheers >>>>> Neha >>>>> >>>>>> On 7/5/14, Kavitha Desai desai <[email protected]> wrote: >>>>>> Hello friends, >>>>>> >>>>>> Can any of the list members help me regarding filtering data in >>>>>> particular column. >>>>>> >>>>>> There is a huge data in Excel sheet 2007. >>>>>> >>>>>> One column contains heading as contacts. >>>>>> >>>>>> This column cells has data as yes, no, reject & blankscells. >>>>>> >>>>>> I want to only filter the cells which contains yes. >>>>>> >>>>>> So how can i filter this data on Excel 2007,. >>>>>> >>>>>> Please guide me step by step as I am using Windows XP as well as >>>>>> Windows 7 Ultimate. >>>>>> >>>>>> Regards, >>>>>> >>>>>> Kavitha >>>>>> >>>>>> >>>>>> >>>>>> Register at the dedicated AccessIndia list for discussing >>>>>> accessibility >>>>>> of >>>>>> mobile phones / Tabs on: >>>>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.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 >>>>>> >>>>>> >>>>>> Disclaimer: >>>>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>>>> of >>>>>> the >>>>>> person sending the mail and AI in no way relates itself to its >>>>>> veracity; >>>>>> >>>>>> 2. AI cannot be held liable for any commission/omission based on the >>>>>> mails >>>>>> sent through this mailing list.. >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Neha Agarwal, >>>>> PC/PMA-Project services, >>>>> IBM India, Hyderabad , AP. >>>>> >>>>> >>>>> >>>>> Register at the dedicated AccessIndia list for discussing >>>>> accessibility >>>>> of >>>>> mobile phones / Tabs on: >>>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.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 >>>>> >>>>> >>>>> Disclaimer: >>>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>>> of >>>>> the >>>>> person sending the mail and AI in no way relates itself to its >>>>> veracity; >>>>> >>>>> 2. AI cannot be held liable for any commission/omission based on the >>>>> mails >>>>> sent through this mailing list.. >>>> >>>> >>>> -- >>>> nothing is difficult unless you make it appear so. >>>> >>>> r. aravind, >>>> >>>> D R O in bank of baroda, >>>> >>>> mobile no: +91 9940369593, >>>> email id : [email protected], [email protected]. >>>> >>>> >>>> >>>> Register at the dedicated AccessIndia list for discussing accessibility >>>> of >>>> mobile phones / Tabs on: >>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.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 >>>> >>>> >>>> Disclaimer: >>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>> of >>>> the >>>> person sending the mail and AI in no way relates itself to its >>>> veracity; >>>> >>>> 2. AI cannot be held liable for any commission/omission based on the >>>> mails >>>> sent through this mailing list.. >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.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 >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the person sending the mail and AI in no way relates itself to its >>> veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.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 >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.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 > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.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 Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
