Tab Within Cell

[Mausi]

I would like to be able tab within Excel cell (Many moons ago in Excel 5 this function was available but was removed since and in a Word table all one has to do is Ctrl + tab).
I have a file set-up but can't (for margin reasons) add additional column so would like to be able 'line up' text with a cell - is there anyway round this.
Thanks in advance.

 

[goesr]

Hi Mausi - I believe what you are trying to do is "indent" within a cell. I'm using MS Office Professional 2010 and there is an indent button on the Home tab in the Alignment section. When mousing over this button the keyboard shortcut is shown as (Ctrl+Alt+Tab). That keyboard shortcut does NOT work for me, but the indent button does.

Hope this helps.

 

[Mausi]

Apologies should have explained myself better, not indent as that will indent everything in cell - what I require is that it aligns e.g.
No. 1 8.1.'14
9.1.'14 and so on
If I could insert extra column it would be simple as I could have above over 2 cells but when I type in Excel cell I cannot get 2nd line to align properly as one could if using tabs in Word.
Thanks

 

[goesr]

Hi Mausi - You have probably tried right justifying the contents of the cell. That seems to work better, if I understand your issue. Sorry to not be more help.

 

[Mausi]

When I viewed my latest post the figures did not align up properly (the 9.1.'14 should be directly under 8.1.'14)

 

[goesr]

Try right justifying the cell so that the '14 is on the far right of the cell.