need to make 4 typical entries regularly in excel

[sameer adhikari]

I need to make 4 typical entries in a particular column, in an excel sheet.
they are:
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...

 

[Pecoflyer]

I need to make 4 typical entries in a particular column, in an exce
sheet.
they are:
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...

If you enter the strings in rows 1 to 4 , starting in row 5 you ca
right-click the cell, select " Pick from drop-down list" and select you
entr

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Aquarius]

Update the Custom List with below entries. Then fill a cell with the first
entry. Then use Auto Fill to fill the rest of the list.

 

[Ashish Mathur]

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