HOW DO I ENTER A NAME WHERE IT SAYS COLUMN A - Z, IT SAYS INVALID

J

jiggityjohnson

HOW DO I ENTER NAMES IN THE BOX LABELED COLUMN A, WHEN I TYPE A NAME IN IT,
IT SAYS IT MUST BE VALID DATA, CANT ANYTHING BE SIMPLE?
 
K

Ken Johnson

Hi Jiggity,
If you are trying to enter text into a cell to which somebody has
previously applied Data Validation that doesn't allow text then you
could receive the invalid data message you mention.
Select one of those cells then go Data>Validation. If in the Allow box
of the Validation Criteria it shows "Any value" then data validation is
not the cause of your problem.
Ken Johnson
 
Top