tab inside cell

[andrew29]

Hi everyone,

nice quick easy one!! How do I tab within an excel cell?? i.e I dont want tab to move me to a new cell just tab inside the cell im working on.

Cheers,

Andrew

 

[Smitty]

That I know of, you don't, but that said,

Tab meaning move ca. five spaces in a line of text?

Tab meaning indent?

Tab meaning start a new line?

What exactly do you want to do?

Smitty

 

[andrew29]

well I want to begin typing in the cell about 5 character spaces from the beginning. Basically I'd like it to function just like in word.

does that help?

thanks

 

[Smitty]

Andrew,

Use the "Increase Indent" button that can be found on the "Formatting Toolbar".

View-->Toolbars-->Formatting

It will indent in increments every time you click for that particular cell or range of cells.

HTH,

Smitty

 

[andrew29]

Thanks heaps for that!! I can't believe that I haven't tried that. The simplest solution is always the easiest to overlook...

Thanks again.

 

[geo09]

Tab inside a cell

Hi, what about using a tab/Bullet inside one cell, only for few lines?
Any nice tricks to do so? I currently use manual spaces but it is not ideal when it come to resizing the column...

What I mean, I need to write a lot of text in one cell and would like to use bullet style, going to the line and showing an indent...
I can find a nice way to do it.

Any tips?

Thanks
Cheers

 

[gino59]

Use Smitty's suggestion for indenting (formatting toolbar) and then press ALT + Keypad 7! Nicely indented bullet!

Cheers,
Gino

 

[maxblockm]

What exactly do you want to do?

Smitty

I have a different thing I am trying to do with using tab inside of a cell, trying to get measurments and numbers to line up

Foot exfoliate mix 1 TSP</SPAN></SPAN>
Body butter ½ TSP</SPAN></SPAN>	Bath Towel, Brown</SPAN> x8</SPAN></SPAN>
Rose Mud 1 TBS </SPAN></SPAN>	Hand Towels x7</SPAN></SPAN>

<TBODY>
</TBODY>

 

[Mausi]

I have a different thing I am trying to do with using tab inside of a cell, trying to get measurments and numbers to line up

Foot exfoliate mix 1 TSP
Body butter ½ TSP	Bath Towel, Brown x8
Rose Mud 1 TBS	Hand Towels x7

<tbody>
</tbody>

I would like to complete same task - (in old Excel 5 this function was available but removed since) and in Word table all you have to do is ctrl + tab, I have template set-up and can't add extra column so would like to 'line up' text within cell - is there anyway round this - thanks in advance.