How to insert tabs into a cell (2002, XP Pro)

Topic

New Reply

Hi all,

Got the ‘flu and the head is slow.
I cannot remember – how do you enter a tab into a cell from the keyboard?

I need thai as I am using Excel to store text strings for use in comparison testing for some automated testing software.
The text I am comparing has embeded tabs, therefore the values in Excel will need to be the same.

Thanks in advance.

Reply | Quote

Replies

Im not sure what you mean by tabs?
sheet tabs?

Reply | Quote

Patrick,

Tabs – the fat key on the side of the keyboard, Character 10, Ctrl-J on the old teletype keyboards.
I know I have entered them previously in excel, I just cannot remember the key combination.

Thanks

Reply | Quote

One way would be to use a formula like this:

="ABC"&CHAR(9)&"DEF"

Reply | Quote

Legare,

Thsi will be a problem for a lot of users who are unfamiliar with the help screens in excel, let alone small formula’s like that.
I was hoping someone could remember the key combination to enter the tab character directly. Similar to how Alt-Enter in a cell inserts a newline.

Thanks

Reply | Quote

As far as I know, there is no way to enter the Tab character in an Excel cell directly.

Reply | Quote

You could also use the VBA procedure below, which could be assigned to a button on the tool bar. However, the cell can’t be in Edit mode to executed the macro. Any text in the cell would have to be entered, the cell reselected, and then the macro executed.

Public Sub InsertTab()
    ActiveCell.Value = ActiveCell.Value & Chr(9)
End Sub

Reply | Quote

One thing that is not mentioned yet is the indents feature. I know it is not tabs as such, but you can use it in a cell to align data off the margin of the cell.

Reply | Quote