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