View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default HELP - How do I allow only 1 char/numb per cell?

so I don't have to press enter or tab after each entry????

To answer your above question without pressing enter or tab..you
cannot...You can only adjust the 'Move selection after enter' as mentioned by
'cm'


If this post helps click Yes
---------------
Jacob Skaria


"Bisonhawk" wrote:

Thank you for the info. I really appreciate it. One more question: Is
there a way to make the cursor automatically go to the right one cell after
entering the 1 char/numb/blank so I don't have to press enter or tab after
each entry???? Thank you very much!!!!

"cm" wrote:

use validation -- on the menu, choose Data Validation. On the Settings tab,
choose Text Length and then select equal to 1 or between 0 and 1, to allow
for possibility of blank.


--
hope to help,
cm


"Bisonhawk" wrote:

I would like to create a spreadsheet that simulates a report and would like
to be able to only enter 1 character or 1 number per cell. Is this possible
in Excel 2003 and how would I go about setting the worksheet to do this?????
Would really appreciate anyones help ASAP if at all possible. Thank you
very much in advance!!