ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tab in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/260047-tab-cell.html)

Maanu

tab in a cell
 
Hi,

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

Thanks!

kassie

tab in a cell
 
You can use the Indent feature. Look for the icon that looks like a
paragraph, with a right arrow to the left of it.

--
HTH

Kassie

Replace xxx with hotmail


"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!


grizzly6969

tab in a cell
 
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!


Dave Peterson

tab in a cell
 
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


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com