LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
prevent data entry into cell? keif Excel Worksheet Functions 3 April 3rd 06 08:37 PM
data in cell not corresponding with entry Graeme New Users to Excel 1 December 21st 05 04:16 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
enter a time into a cell, have the cell show two times the entry johnp Excel Worksheet Functions 3 May 2nd 05 12:08 AM


All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"