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