Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I make a particular column required in Excel?
Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any advice or help! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I make a particular column required in Excel?
You could use an IF Statement in your final sum. Something like:
=IF(B10="","Please complete Column B",SUM(C1:C10)) Change cell references and messages to suit your needs. HTH, Elkar "smistretta" wrote: Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any advice or help! |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I make a particular column required in Excel?
You could also use Data Validation in the Projects cells with a type of
Custom and a formula of say =B10<"" (for row 10). Make sure you uncheck the Ignore Blanks box. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Elkar" wrote in message ... You could use an IF Statement in your final sum. Something like: =IF(B10="","Please complete Column B",SUM(C1:C10)) Change cell references and messages to suit your needs. HTH, Elkar "smistretta" wrote: Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any advice or help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make a cell required in excel | Excel Discussion (Misc queries) | |||
How do I make all numbers in a column negative in excel 2000? | Excel Discussion (Misc queries) | |||
Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |