Restrict Cell Entry

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Restrict Cell Entry

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-26-2015, 01:08 PM

Cardinal2

Windows 7 64bit Restrict Cell Entry

Office 2007

Novice

Join Date: Feb 2013

Posts: 10

Restrict Cell Entry

I have a spreadsheet cell that I would like to restrict entries of:
m, M, f, F, only.
I have data validation set up for the cell listing those 4 entries.

When ever someone enters a name such as matthew or Mary, the auto correct will

change the m entry into matthew.

Turning off the "AutoCorrect" is NOT an option.
Is there another way of limiting entries into this cell for the 4 entries listed above

thanks for any help
Cardinal 32

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict data validation based upon a cell value	Strategic	Excel	2	01-27-2015 02:13 AM
Restricting Cell Entry to "N12345678"	balbas662	Excel	3	11-27-2014 12:46 PM
Restrict access to content?	Zeratul	Word	2	09-05-2014 05:40 AM
To restrict the Accumlate Sum	MamaMonster	Excel	2	03-16-2014 01:49 AM
Trying to update a table cell with a value based on a drop down box entry	mkasem	Word VBA	2	09-29-2013 08:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 PM.