Data Validation - Restrict entry but without dropdown
 

I found the following question and helpfull result however I also would like
to not worry about the drop down in the cell. They are very narrow columns
and they just are unnecessary for only two options.

I just want my cells to only accept R or C - I have done this as suggested
below but dont really want the drop down list.

Select the impacted cells
DataData Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"aetzkin" wrote:

I am trying to format a cell so that it will only accept the characters H or
F and reject all others.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

Data Validation - Restrict entry but without dropdown
 

Hi,

Do it with a Data Validation formula

Lets say your range starts in A1, select the cells and then

Data|Validation - Formula
enter the formula

=OR(A1="C",A1="R")

Mike

"Leanne M (Aussie)" wrote:

I found the following question and helpfull result however I also would like
to not worry about the drop down in the cell. They are very narrow columns
and they just are unnecessary for only two options.

I just want my cells to only accept R or C - I have done this as suggested
below but dont really want the drop down list.

Select the impacted cells
DataData Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"aetzkin" wrote:

I am trying to format a cell so that it will only accept the characters H or
F and reject all others.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

Data Validation - Restrict entry but without dropdown
 

You can still use the Allow: List option just uncheck the In-Cell Drop Down
option.

Note that this is case sensitive. If you enter as the source R,C lower case
r and c will be rejected. If you don't want this to be case sensitive use as
the source: R,r,C,c.

--
Biff
Microsoft Excel MVP


"Leanne M (Aussie)" wrote in
message ...
I found the following question and helpfull result however I also would
like
to not worry about the drop down in the cell. They are very narrow
columns
and they just are unnecessary for only two options.

I just want my cells to only accept R or C - I have done this as suggested
below but dont really want the drop down list.

Select the impacted cells
DataData Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"aetzkin" wrote:

I am trying to format a cell so that it will only accept the characters H
or
F and reject all others.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)