ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to make the enter button work as regular enter (https://www.excelbanter.com/excel-discussion-misc-queries/248305-re-there-way-make-enter-button-work-regular-enter.html)

Ricter

Is there a way to make the enter button work as regular enter
 
Alternatively,
Tools Options Edit "Move selection after Enter" Direction = Down.



"pageisbusy" wrote:

Cancel i found the answer! yeah!
if you hit alt enter then it works like a reular enter button :-)

"pageisbusy" wrote:

I want to use my enter button as a regular enter button within a cell. I do
not want to move the cursor, I want to go to the next line like in typing
normally.
I have cells set to wrap text
I have unchecked the option of moving cursor when enter is hit
what else do i need to do?
Thank you
(I don't know anything about adding a macro -- if this needs one it would be
helpful for me to know EXACTLY wehre to go and how to do it Thanks!)


Bill Sharpe

Is there a way to make the enter button work as regular enter
 
Ricter wrote:
Alternatively,
Tools Options Edit "Move selection after Enter" Direction = Down.



"pageisbusy" wrote:

Cancel i found the answer! yeah!
if you hit alt enter then it works like a reular enter button :-)

"pageisbusy" wrote:

I want to use my enter button as a regular enter button within a cell. I do
not want to move the cursor, I want to go to the next line like in typing
normally.
I have cells set to wrap text
I have unchecked the option of moving cursor when enter is hit
what else do i need to do?
Thank you
(I don't know anything about adding a macro -- if this needs one it would be
helpful for me to know EXACTLY wehre to go and how to do it Thanks!)


No, that moves him down to the next cell. He found the answer already.

Bill


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com