View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
englishtwit
 
Posts: n/a
Default Auto Entry in a Cell


Hi

This sounds simple, but I am flummuxed.

I doing alot of fast analysis that requires me to enter Y or N in a
cell, then move down one line.

ie
I press Y, then the down arrow to move to the cell underneath.

Is there a way of setting or formating the cell so that you only have
to press Y (or N) and the cursor will move to the next line?

I've tried setting up a macro with a shortcut key, but Excel doesn't
record the down arrow, or the carraige return.

I am using Excel 2003.

Looking forward to the usual great responses!

ET


--
englishtwit
------------------------------------------------------------------------
englishtwit's Profile: http://www.excelforum.com/member.php...fo&userid=5464
View this thread: http://www.excelforum.com/showthread...hreadid=542853