View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default need to make 4 typical entries regularly in excel

Hi,

You can use Data Validation. Enter the 4 values in a range and then go to
Data Validation List. In the source, give the reference of the 4 cells.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sameer adhikari" <sameer wrote in
message ...
I need to make 4 typical entries in a particular column, in an excel
sheet.
they a
1. Project in process
2. Project on Hold
3. Project won
4. Project Lost

Requests please tell me the simplest way to make these entries without
typing these entries again & again...