| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create two lines in one cell
I want to create a second line within one cell so gthat the print within the
cell will wrap at a requested position. The end result would look like this for one cell: HERTZ - 7 day car rental |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create two lines in one cell
Type
HERTZ - Click Alt+Enter Type your second line of text Mike "garrett" wrote: I want to create a second line within one cell so gthat the print within the cell will wrap at a requested position. The end result would look like this for one cell: HERTZ - 7 day car rental |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create two lines in one cell
Use ALT_ENTER. The wrap only shows after your entry is finished
-- Kind regards, Niek Otten Microsoft MVP - Excel "garrett" wrote in message ... |I want to create a second line within one cell so gthat the print within the | cell will wrap at a requested position. The end result would look like this | for one cell: | | HERTZ - | 7 day car rental |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create two lines in one cell
Thank you very much. I could not find that info anywhere!
"Mike H" wrote: Type HERTZ - Click Alt+Enter Type your second line of text Mike "garrett" wrote: I want to create a second line within one cell so gthat the print within the cell will wrap at a requested position. The end result would look like this for one cell: HERTZ - 7 day car rental |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create two lines in one cell
Thank you, I wasn't able to find that info in the Exel database. I tested it
and it works on my Exel 2003. "Niek Otten" wrote: Use ALT_ENTER. The wrap only shows after your entry is finished -- Kind regards, Niek Otten Microsoft MVP - Excel "garrett" wrote in message ... |I want to create a second line within one cell so gthat the print within the | cell will wrap at a requested position. The end result would look like this | for one cell: | | HERTZ - | 7 day car rental |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create two lines in one cell
HelpMultiple lines reveals this info....
Display multiple lines of text within a cell Select the cells you want to format. On the Format menu, click Cells, and then click the Alignment tab. Under Text control, select the Wrap text check box. Tip To start a new line of text at a specific point, click where you want to break the line, and then press ALT+ENTER. Gord Dibben MS Excel MVP On Sat, 26 Jan 2008 03:06:02 -0800, garrett wrote: Thank you very much. I could not find that info anywhere! "Mike H" wrote: Type HERTZ - Click Alt+Enter Type your second line of text Mike "garrett" wrote: I want to create a second line within one cell so gthat the print within the cell will wrap at a requested position. The end result would look like this for one cell: HERTZ - 7 day car rental |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create several lines in one cell? | Excel Discussion (Misc queries) | |||
| How do you create multiple lines within a cell? | Excel Discussion (Misc queries) | |||
| How to create chart with columns and 2 lines? | Charts and Charting in Excel | |||
| How do you create or set up time lines | Charts and Charting in Excel | |||
| How to create chart with 1 column and 3 lines | Charts and Charting in Excel | |||
Linear Mode
