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