again in excel how to format cell(s) so that a cell will contain one letter only?

Question

I am devising a format for a questionaire .The answers or the letters of the answers must be placed in adjacent cells one each cell ,a space,comma,etc will also be considered as a single letter

I havent got an answer for my quetion.....

to further elucidate... I need that when you enter one charecter in a cell the cursor should automatically move to the next cell

Answer 1

I do not think it is possible to do in excel. To change cells you need to either press enter, tab or shift and tab.

You could try:
Select the cells and go to the "Format" menu, and "Cells ..." menu item. Select the "custom" style and create one character in there. I am not sure if it would work perhaps just having one underline, ie '_'

Answer 2

http://spreadsheets.about.com/od/exceltutorialsandtips/ss/blexdropboxes_4.htm

Sounds like you want a Drop Down Box List in Excel
Now that you have your list, go back to the worksheet where you want the drop down box to appear. Make the active cell the one where you want the list to appear (if you want to use the drop down box for more than one cell, just select the entire range that you need). In the "Data" menu, select "Validation". This will bring up the Validation window.

http://www.pcworld.com/article/id,105312-page,1/article.html

Answer 3

in case you purely would desire to do it as quickly as then reproduction the time on my own right into a separate column (formulation the place cellular is the cellular that incorporates the date/time records =MOD(cellular,a million) then drag to fill the the remainder of the information and format the column as time) form on that column on my own and delete all rows that fall interior the bounds you describe. Then form lower back by potential of the unique form technique.

Answer 4

format the cells where you want the response as "Text" You'll see that you can put anything in there...

Answer 5

... and your question is...?