ExcelBanter - Program "Enter" Key

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Program "Enter" Key (https://www.excelbanter.com/excel-worksheet-functions/91541-program-enter-key.html)

Merlin

Program "Enter" Key

How can you program the "ENTER" key to enter a new line in an Excel Cell?

Ron Coderre

Program "Enter" Key

Try this:

While editing a cell....hold down the [alt] key and press [enter].

That will insert a new line in the cell.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"Merlin" wrote:

How can you program the "ENTER" key to enter a new line in an Excel Cell?

Matt Lunn

Program "Enter" Key

"Merlin" wrote:

How can you program the "ENTER" key to enter a new line in an Excel Cell?

Hold down the Alt key when you press enter for a new line when editing the
cell(if that's what you were asking). No idea how you'd be able to this just
by pressing Enter though. Stick the Alt key down with glue maybe? :)

Chip Pearson

Program "Enter" Key

You can't. Just use ALT+ENTER instead.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Merlin" wrote in message
...
How can you program the "ENTER" key to enter a new line in an
Excel Cell?

Daniel CHEN

Program "Enter" Key

In Excel itself, use Alt+Enter.
In VBA use Chr(10) like: Cells(1, 1) = "AA" & Chr(10) & "BB"

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Merlin" wrote in message
...
How can you program the "ENTER" key to enter a new line in an Excel Cell?

All times are GMT +1. The time now is 12:22 AM.