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..