| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you do hard returns in 1 cell? entering address in 1 cell
Excel does not seem to have a feature for entering hard returns in a cell.
An example is when you are entering an address. How do you get that information into one cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you do hard returns in 1 cell? entering address in 1 cell
Press Alt+ENTER to break for a new line within a cell
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jenn" wrote: Excel does not seem to have a feature for entering hard returns in a cell. An example is when you are entering an address. How do you get that information into one cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you do hard returns in 1 cell? entering address in 1 cell
If I understand your requirement, do Alt+Enter at end of each address line.
Given that I don't know your application, I would advise having address lines as entries in separate columns rather than in one cell. "Jenn" wrote: Excel does not seem to have a feature for entering hard returns in a cell. An example is when you are entering an address. How do you get that information into one cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering an address in one cell | Charts and Charting in Excel | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| Hard returns in a formula? | Excel Worksheet Functions | |||
| How to put hard returns in a cell without going to the next cell | Excel Discussion (Misc queries) | |||
| Hard Returns in a Cell (or two lines in a cell) | Excel Discussion (Misc queries) | |||
Linear Mode
