Prev: counting identical items in a column and returning the occurre
Next: printer paper will not advance
From: Maanu on 27 Mar 2010 00:36
Hi,

How can I put a tab in a cell?. If I press the tab key, the control goes to
the next cell.

Thanks!
From: grizzly6969 on 27 Mar 2010 01:58
go to Tools / Options / Transition / Transition Navigation Key and remove
check mark
--
grizz


"Maanu" wrote:

> Hi,
>
> How can I put a tab in a cell?. If I press the tab key, the control goes to
> the next cell.
>
> Thanks!
From: Dave Peterson on 27 Mar 2010 08:53
You could use =char(9) like:

="Some text before the tab"&char(9)&"some text after the tab"

But you'll see a little square where the tab character is. Excel isn't much of
a word processor.

Depending on what you're doing, you may find using a table in MSWord easier.

Maanu wrote:
>
> Hi,
>
> How can I put a tab in a cell?. If I press the tab key, the control goes to
> the next cell.
>
> Thanks!

--

Dave Peterson
 | 
Pages: 1
Prev: counting identical items in a column and returning the occurre
Next: printer paper will not advance