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

sameer adhikari;242230 Wrote:
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...

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67548

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.

"sameer adhikari" wrote:

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

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