Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I ENTER A NAME WHERE IT SAYS COLUMN A - Z, IT SAYS INVALID
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I ENTER A NAME WHERE IT SAYS COLUMN A - Z, IT SAYS INVALID
It sounds to me as though you might be trying to use a named range name, tho
I can't be sure. Here's how it's done if that's what you're wanting to do: http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "jiggityjohnson" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I ENTER A NAME WHERE IT SAYS COLUMN A - Z, IT SAYS INVALID
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 DataValidation. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How to enter a two line column heading in excel | New Users to Excel | |||
Is there a way I can enter a letter to proceed text a column of ce | Excel Discussion (Misc queries) |