ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you tab in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/40018-how-do-you-tab-cell.html)

Dastik

How do you tab in a cell?
 
i want to tab the text over in a cell. If i push Tab it goes to next
cell...i dont' want that .....help!!!

Michael

Hi
I don't believe you can do this within a cell
If you want to create a new line within a cell, press Alt + Enter
Otherwise , use the space bar to create your Tab distance
HTH
Michael Mitchelson


"Dastik" wrote:

i want to tab the text over in a cell. If i push Tab it goes to next
cell...i dont' want that .....help!!!


Casey


Dastik,
I'm hoping I understand what you are trying to do. If you have text in
a cell and simply want to indent the text within the cell, then you can
do so by going to FormatCells and clicking the Alignment Tab.
There to the immediate right of the horizontal alignment drop down is
the indent spinner control. See if that does what you want. Also, this
same feature is normally available on the format tool bar as two icons
which look like outlined text, one for decrease indent and one for
increase indent.

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=395163


cafe


I think what you are trying to do is "indent' your text in a cell. If
this correct, in excel menu you should see an icon named "Increase
Indent". This is part of your Format tool bar.

Hope this is what you are looking for.

Regards,
Cafe


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=395163


Dodo

?B?RGFzdGlr?= wrote in
:

i want to tab the text over in a cell. If i push Tab it goes to next
cell...i dont' want that .....help!!!


You mean indent text in a cell?

There is a standard button for that in the format bar (the button with a
small arrow pushing a paragraph to the right).


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com