How can I insert a Tab inside an Excel cell?

Question

How can I insert a Tab inside an Excel cell?

Estep, Brian 0

There was another thread asking this question. The accepted answers said that this was impossible. But... it is not impossible. I do not think there is a way to do it by typing a tab character in the formula bar, but you can absolutely get a tab character into an Excel cell.

Method 1: copy/paste a "tab" character into an Excel cell. To test this out, open a word document, type "1" and then "tab," then copy/paste this into an Excel cell using the formula bar. Next, right align the cell. You will see that the "1" does not align all the way to the right.

In the next cell, type "1". You will see that it aligns all the way to the right. In the next cell, type "1" and "space". You will notice that the space disappears, and the 1 aligns all the way to the right. The tab however, remains, and is not fully right-aligned. This proves that it is possible to get a tab character into an Excel cell.

Method 2: In the formula bar, type ="1"&CHAR(9). This should achieve the same result as Method 1. To remove the formula, you can copy and "paste values" over the cell itself. Presto, now you have a tab character.

Curious to hear any thoughts or if anyone out there knows a quicker/easier method to get a tab character into a cell using the formula bar itself?

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Kai-L 17,650 Microsoft External Staff Moderator

Dear Brian,

Thank you for taking the time to test this and write it up. Your right alignment test is a neat way to demonstrate it. I suspect the earlier thread was answering a slightly different question, since Excel does not render a tab as indentation inside a cell the way Word does. So tab as a formatting behavior is not available, but tab as a character certainly is, which is what you have shown. I am not aware of a quicker way to do it directly in the formula bar, as typing the key moves to the next cell rather than entering the character. I will leave this thread open in case other members of the community know of one.

Thank you again for being a valued member of the Q&A community and I wish you all the best!

Estep, Brian 0 Reputation points

2026-08-26T16:14:04.3533333+00:00

The other post didn't specify they were looking for indentation, but you could be right - maybe that is what they were looking for. If that's the case, then I would agree, there is no way to indent in Excel based on a tab as the first character. In that case, I would recommend something this (below, with periods in front of the tabs) as a workaround. Thanks for the insight, though! I will accept your response as the answer and hope someone finds this useful in the future. Thanks!

parent

.(tab)child A

.(tab).(tab)grandchild A

.(tab).(tab)grandchild B

.(tab)child B
Kai-L 17,650 Reputation points Microsoft External Staff Moderator

2026-08-26T16:27:35.0866667+00:00

Dear Brian,

Thank you for accepting the answer, and for the workaround. Using a leading period to anchor the tabs is a neat trick, and it makes the hierarchy readable without needing true indentation. Worth mentioning that Excel also has a built in Increase Indent button on the Home tab if the goal is purely visual, though your approach has the advantage of keeping the structure in the cell value itself, which is useful if the data is exported later.

Thanks again for sharing this. I am sure others searching the same question will find the thread helpful.