Insert a Tab character in Excel
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.
Insert a Tab character inside cell
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.
Insert a Tab character in Excel
I was also facing similar type of issue i try to use the below steps for inserting a tab character in Excel 2007.
- Select the cell that contains the text you want to indent.
- Click on Format menu and Click on Cells.
- Again click on Alignment tab.
- 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.
- Finally click on OK button.