How to change the direction of the enter key to go horizontal

B

BManske

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.
 
M

Michael Arch

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.
 
G

Glenn

BManske said:
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.
Click to expand...


Tools / Options / Edit / Move selection after edit:
 
T

T. Valko

In Excel 2007...

Office button>Excel Options>Advanced>Editing Options: After pressing Enter,
move selection.....>OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Move Chart with Text 0
How do I change the direction when pressing ENTER? (dn, rt, etc.) 3
Export BPMN Visio Chart to Excel 0
Office 2007 How do I change the direction of the enter key betwee. 1
how to link horizontal data to vertical cells in a new sheet 1

Top