$$Excel-Macros$$ Re: Auto complete list popup windo in excel

2009-09-01 Thread Dilip Pandey
Hi Prashanth, Off-Course it is a valid suggestion.!!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Sep 1, 2009 at 5:59 PM, Prashanth Banneni wrote: > Hello Dilip Sir, > > If there is data in the same

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

2009-09-01 Thread Prashanth Banneni
Hello Dilip Sir, If there is data in the same column above then Press Alt+ Down Arrow. This will show the list of the unique values above. As i am a beginner in excel Let me know if this is a valid sugestion. Thanks Prashanth On Tue, Sep 1, 2009 at 10:36 AM, Dilip Pandey wrote: > Hi Vidyut

$$Excel-Macros$$ Re: Auto complete list popup windo in excel

2009-08-31 Thread Dilip Pandey
Hi Vidyut, As per my knowledge, you can set the validation by choosing any of the available option which are there in Data->Validation, but then you have to choose the desired item manually from the drop down.. Alternatively, if the data is already typed in the column, then Excel itself shows auto