| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Program "Enter" Key
How can you program the "ENTER" key to enter a new line in an Excel Cell?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? :) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| horse racing excel program | Excel Discussion (Misc queries) | |||
| Need Help Initializing Excel Spreadsheet Program | Excel Discussion (Misc queries) | |||
| How to display a form- to show status of the running program | Excel Discussion (Misc queries) | |||
| Hyperlink in Excel opens the right program, but can't read file. | Excel Discussion (Misc queries) | |||
| Charts causing program to crash | Charts and Charting in Excel | |||
Linear Mode
