Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use the tabs in excel
I am entering a text in a cell, and I need to use the TABulations to indent
parts of the text (not all the cell). 1 - like that 2 - all in one cell THANKS A LOT |
#2
|
|||
|
|||
Micheline
To get two lines in one cell Type 1 - like that then hit ALT + ENTER to get a line break then type 2 - all in one cell To indent you must then go to FormatAlignmentHorizontalIndent Gord Dibben Excel MVP On Thu, 14 Apr 2005 15:34:02 -0700, Micheline wrote: I am entering a text in a cell, and I need to use the TABulations to indent parts of the text (not all the cell). 1 - like that 2 - all in one cell THANKS A LOT |
#3
|
|||
|
|||
Gord,
This will indent the whole cell. I wanted to have a text in the cell not indented, and then add 2 lines with indentations: 1-like that 2-and the second like that. Thank you "Gord Dibben" wrote: Micheline To get two lines in one cell Type 1 - like that then hit ALT + ENTER to get a line break then type 2 - all in one cell To indent you must then go to FormatAlignmentHorizontalIndent Gord Dibben Excel MVP On Thu, 14 Apr 2005 15:34:02 -0700, Micheline wrote: I am entering a text in a cell, and I need to use the TABulations to indent parts of the text (not all the cell). 1 - like that 2 - all in one cell THANKS A LOT |
#4
|
|||
|
|||
Excel really doesn't make much of a word processor. You can add a tab in the
cell: =char(9)&"1-like that" but excel will only show you a little box. When I've had to do this, I've just used the space bar. And when I used a font of courier-new (fixed width), it lines up nicely. Micheline wrote: Gord, This will indent the whole cell. I wanted to have a text in the cell not indented, and then add 2 lines with indentations: 1-like that 2-and the second like that. Thank you "Gord Dibben" wrote: Micheline To get two lines in one cell Type 1 - like that then hit ALT + ENTER to get a line break then type 2 - all in one cell To indent you must then go to FormatAlignmentHorizontalIndent Gord Dibben Excel MVP On Thu, 14 Apr 2005 15:34:02 -0700, Micheline wrote: I am entering a text in a cell, and I need to use the TABulations to indent parts of the text (not all the cell). 1 - like that 2 - all in one cell THANKS A LOT -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel should display tabs on multiple rows | Excel Worksheet Functions | |||
Opening worksheets in seperate excel tabs | Excel Worksheet Functions | |||
Copying Tabs in Excel | Excel Discussion (Misc queries) | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |