How to Insert a Tab Character In a Cell

When you are adding data to any of the cells in your spreadsheet you may not always want the text to start the far left end. In some circumstances the formatting of the cell may be more visually appealing if there is a tab character added first. Unfortunately you can't add a tab simply by pressing the keyboard's "tab" key inside the cell. Depending on the version of your spreadsheet there are two different ways to insert a tab character into an active cell.

Video of the Day

Insert a tab character into a spreadsheet cell


Open your Excel workbook and navigate to the worksheet you are working with. Click inside the cell that you want to modify.


Press the "Ctrl," "Alt," and "Tab" keys simultaneously and see if a tab character is added to the active cell. Click the "Format" button if the key combination does not add the tab character.


Click "Cells" and then navigate to "Alignment." Click "Left Indent" and then click the arrow key to add in an indentation that is the equivalent of a tab character. Click again to add another level of indentation.

Show Comments