Excel: Entering Multiple Lines in an Input Box

• Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
• Microsoft Excel for OS/2 version 3.0

In Microsoft Excel versions 4.x and earlier, although you can use ALT+ENTER to create a linefeed character in worksheet cells, this key combination does not work in input boxes created with the INPUT() function.

To enter multiple lines of information into an input box:

• Enter the information and, at the end of each line, press the ALT key and type 010 (on the numeric keypad) to create a linefeed character.

Note that in order for the information to appear in a cell in a multiple- line format, you must apply the Wrap Text alignment feature to the cell.

NOTE: If you are using Microsoft Excel version 5.0, you must use this procedure to enter multiple lines of text in an input box created on a Microsoft Excel version 4.0 macro sheet.

REFERENCES

"Function Reference," version 4.0, pages 241-242 "Function Reference," version 3.0, pages 131-132