I have to enter a lot of data in cells that need to break the line and I need
every time to use "alt + Enter".
I would like to be able to swap the "Enter" and the "Alt+Enter"
functionality, ie, exchange the key strokes but keep the functionality

Thanks for the tip

Gerson

Hi Gerson,
That would be a very bad thing to do in my opinion.
Are you aware of Text Wrap using Format,cells, aligmnet, wrap text.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gerson" wrote in message ...
I have to enter a lot of data in cells that need to break the line and I need
every time to use "alt + Enter".
I would like to be able to swap the "Enter" and the "Alt+Enter"
functionality, ie, exchange the key strokes but keep the functionality

Thanks for the tip

Gerson

Hi

Thanks for your prompt reply, but unfortunately I think my question was not
understood, and the solution does not solve the problem.
I need to enter a lot of cells with info like this:
_______________________________
To be able to do the test, perform the following opperations:<nl
1- stop server<nl
2- connect the HW<nl
3- start the server<nl
After completion, set the register:<nl
- to 1 if it is OK<nl
- to 2 if it was not OK<nl
etc..
________________________________

As you can see, I have a lot of <nl (Alt+Enter) in the text, and every time
I need to type ALT+ENTER, wich is anoying. I thought that Excel was smart
enought to change this behaviour in some way.

I found that I can deactivate the ENTER behaviour, by selecting
'tool,option,edit. move selection after enter' , but this does only part of
the job because after 'enter' the line is overwriten if a new is entered.
the right approach should be to add a new parameter: Direction = 'new line'
To move to other cells I can use the arrow keys.

Regards
Gerson

"David McRitchie" wrote:

Hi Gerson,
That would be a very bad thing to do in my opinion.
Are you aware of Text Wrap using Format,cells, aligmnet, wrap text.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gerson" wrote in message ...
I have to enter a lot of data in cells that need to break the line and I need
every time to use "alt + Enter".
I would like to be able to swap the "Enter" and the "Alt+Enter"
functionality, ie, exchange the key strokes but keep the functionality

Thanks for the tip

Gerson

Hi Gerson,
You can't intercept keystrokes.
What you could do is use another character and convert that
to CHR(10) using a macro afterwards for a large selection.
The keys I can think of (| or ^) are two key combinations just like Alt+Enter.

You will have to turn cell wrap on yourself preferably for entire column
since you won't have Alt+Enter doing that for you.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gerson" wrote in message ...
Hi

Thanks for your prompt reply, but unfortunately I think my question was not
understood, and the solution does not solve the problem.
I need to enter a lot of cells with info like this:
_______________________________
To be able to do the test, perform the following opperations:<nl
1- stop server<nl
2- connect the HW<nl
3- start the server<nl
After completion, set the register:<nl
- to 1 if it is OK<nl
- to 2 if it was not OK<nl
etc..
________________________________

As you can see, I have a lot of <nl (Alt+Enter) in the text, and every time
I need to type ALT+ENTER, wich is anoying. I thought that Excel was smart
enought to change this behaviour in some way.

I found that I can deactivate the ENTER behaviour, by selecting
'tool,option,edit. move selection after enter' , but this does only part of
the job because after 'enter' the line is overwriten if a new is entered.
the right approach should be to add a new parameter: Direction = 'new line'
To move to other cells I can use the arrow keys.

Regards
Gerson

"David McRitchie" wrote:

Hi Gerson,
That would be a very bad thing to do in my opinion.
Are you aware of Text Wrap using Format,cells, aligmnet, wrap text.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gerson" wrote in message ...
I have to enter a lot of data in cells that need to break the line and I need
every time to use "alt + Enter".
I would like to be able to swap the "Enter" and the "Alt+Enter"
functionality, ie, exchange the key strokes but keep the functionality

Thanks for the tip

Gerson