Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to make 4 typical entries regularly in excel
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to make 4 typical entries regularly in excel
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to make 4 typical entries regularly in excel
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... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |