Insert a Tab character in Excel

[Chhaya]

I am working in excel 2003 where i want to insert a tab character in one of my Worksheet.Since i was new to excel so i asked my friends about the same and they told me to press Ctrl+ Alt+ Tab for inserting a character.I have try to do it but it's not allowing me to do so. Can anyone direct me or tell me what i need to do for inserting a tab character in my Excel file.

[Raine]

Try to use Alt+ Enter in your Worksheet hope it should work if it doesn't work then you need to concatenate a tab character inot a string by using the following code into A2 cell ="A"&CHAR(9)&"B" and =LEN(A2) in B2 cell.

[Francesca]

I was also facing similar type of issue i try to use the below steps for inserting a tab character in Excel 2007.

1. Select the cell that contains the text you want to indent.
   
   
2. Click on Format menu and Click on Cells.
   
   
3. Again click on Alignment tab.
   
   
4. Over here in the Horizontal list, click Left(Indent) and type the amount by which you want to indent the text. Or, click the arrows in the Indent box.
   
   
5. Finally click on OK button.