Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-12 Thread Kavitha Desai desai
Friends, I tried using the key commands provided in this mail, but I am not able to select only yes contents from the data after it says auto filter dropdown. Is there any list members who can come on Skype help. My Skype id : kavita.rd Regards, Kavitha On 7/9/14, Mahesh Narasimhan

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-09 Thread Mahesh Narasimhan
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

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-08 Thread Neha Agarwal
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

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-07 Thread echo glad
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

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-06 Thread Aravind R
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

[AI] Query regarding auto filtering in Excel 2007

2014-07-05 Thread Kavitha Desai desai
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.

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-05 Thread Zoher Kheriwala
Here I am asuming you are using office 7. Do the following, 1. press alt +a t. to activate auto filter. 2. go to column heading where you want to filter, the jaws will announce auto filter dropdown. 3. Press the alt + down arrow. 4. Select the Items which you want to display by pressing spacebar

Re: [AI] Query regarding auto filtering in Excel 2007

2014-07-05 Thread Neha Agarwal
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.