Force Return Key to Linebreak

teeman

New Member
Joined
May 10, 2005
Messages
14
Hi

I'm looking for a macro or some way to force the Return Key to have the behaviour of Alt+Return.. ?

Is this possible?

I have a spreadsheet that is used as a form and some for the cells have been merged. When the user presses "Return" I would like them to goto the next line.

Thanks

Nic Teeman
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

BJungheim

Well-known Member
Joined
Jul 24, 2004
Messages
914
You can't fire off a macro when you're editing a cell...if there's a system setting you can change I don't know.
 

teeman

New Member
Joined
May 10, 2005
Messages
14
I don't just want this for indiviual parts of the spreadsheet.

I always want the enter key to alt+enter through the entire workbook..

Or is it still the same?

Thanks

Nic
 

Watch MrExcel Video

Forum statistics

Threads
1,114,060
Messages
5,545,761
Members
410,704
Latest member
Cobber2008
Top