View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Raymond Raymond is offline
external usenet poster
 
Posts: 9
Default Set cell to only accept 1 character

I need to format several cells to only accept one character and then
automatically move to the next cell. Can this be done in Excel 2003? We
have to fill out a spreadsheet and several cells are one character wide but
we have to hit the tab key after each character to get it to move to the next
cell. This is hard when entering 20 or more of these one character cells in
a row.