Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Typical Problem | Excel Worksheet Functions | |||
Regularly email spreadsheets | Excel Discussion (Misc queries) | |||
Regularly used files | Excel Discussion (Misc queries) | |||
Typical excel interviewing questions | Excel Discussion (Misc queries) | |||
How do I make more than 12 entries in excel balance sheet templat. | Excel Discussion (Misc queries) |