Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 21st 09, 10:03 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 1
Default How to change the direction of the enter key to go horizontal

I recall when entering data in an excel chart, that I could change the
direction from vertical to horizontal when using the "enter" key.....and
can't remember where I went to change that.

  #2   Report Post  
Old October 21st 09, 10:08 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 32
Default How to change the direction of the enter key to go horizontal

From the Main Menu Select:
Tools-Options
Select the Edit Tab
From the Dropdown Box select the direction where you will move after hitting
enter, in your case right or left

--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.




"BManske" wrote:

I recall when entering data in an excel chart, that I could change the
direction from vertical to horizontal when using the "enter" key.....and
can't remember where I went to change that.

  #3   Report Post  
Old October 21st 09, 10:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,240
Default How to change the direction of the enter key to go horizontal

BManske wrote:
I recall when entering data in an excel chart, that I could change the
direction from vertical to horizontal when using the "enter" key.....and
can't remember where I went to change that.



Tools / Options / Edit / Move selection after edit:
  #4   Report Post  
Old October 21st 09, 10:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,240
Default How to change the direction of the enter key to go horizontal

Glenn wrote:
BManske wrote:
I recall when entering data in an excel chart, that I could change the
direction from vertical to horizontal when using the "enter"
key.....and can't remember where I went to change that.



Tools / Options / Edit / Move selection after edit:



"after Enter" not "after edit"
  #5   Report Post  
Old October 21st 09, 10:32 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default How to change the direction of the enter key to go horizontal

In Excel 2007...

Office buttonExcel OptionsAdvancedEditing Options: After pressing Enter,
move selection.....OK

--
Biff
Microsoft Excel MVP


"BManske" wrote in message
...
I recall when entering data in an excel chart, that I could change the
direction from vertical to horizontal when using the "enter" key.....and
can't remember where I went to change that.





  #6   Report Post  
Old April 9th 15, 06:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1
Default How to change the direction of the enter key to go horizontal

is there any way to make it so when i hit enter it moves horizontally when im using Excel for Ipad? I need to go to the next column when enter is pressed..

thanks!


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
change direction when pressing enter RickMoore Excel Discussion (Misc queries) 7 August 11th 09 04:31 PM
How do I change the direction when pressing ENTER? (dn, rt, etc.) CGN Bear Excel Worksheet Functions 3 July 15th 09 06:29 PM
change direction when hitting enter key Using Excel in Conifer Excel Discussion (Misc queries) 1 March 5th 09 09:13 PM
How do I change the direction of the cell when I press enter jonathan New Users to Excel 1 January 8th 09 03:25 PM
How do I change cursor direction after enter in 2007? wheape1 Excel Discussion (Misc queries) 3 May 14th 07 09:24 PM


All times are GMT +1. The time now is 11:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017