#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robert
 
Posts: n/a
Default shortcut

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.
--
Robert Rogers
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default shortcut

You can configure Excel to move one cell in a direction of your choosing (or
not at all). Tools Options. Click on the Edit tab, check the 'Move
selection after Enter' box and use the drop-down to pick the direction.

"robert" wrote:

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.
--
Robert Rogers

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default shortcut

The only choices are Down, Right,Up and Left one cell at a time.

Or don't move at all.

If you wanted to move from say A1 to D2 and over to F3 you must use another
method.

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 16:46:03 -0800, robert
wrote:

When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing.
Thank you.


Reply
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
Shortcut Keys -- quick find scottech Excel Discussion (Misc queries) 3 November 15th 05 09:08 PM
Deactivate shortcut keys in excel.. areddy Excel Discussion (Misc queries) 1 October 25th 05 03:37 PM
Isolating a Keyboard Shortcut RWN Setting up and Configuration of Excel 1 October 23rd 05 10:55 PM
how can you customize a shortcut menu in excel? fredk Excel Discussion (Misc queries) 2 March 25th 05 05:25 AM
Shortcut menu does not have hyperlink on it Kelli Excel Discussion (Misc queries) 2 February 24th 05 07:59 PM


All times are GMT +1. The time now is 01:49 AM.

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"