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 <gladecho...@gmail.com> 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 <aravind.andhrab...@gmail.com> 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 <tweety....@gmail.com> 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 <kavitha.desa...@gmail.com> 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/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 >>>> >>>> >>>> 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/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 >>> >>> >>> 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 : aravind_...@yahoo.com, aravind.andhrab...@gmail.com. >> >> >> >> 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/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 >> >> >> 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/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 > > > 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/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 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..