View Single Post
  #2   Report Post  
Ian
 
Posts: n/a
Default

There is probably dat in the adjacent cells (maybe just spaces). Excel will
not carry data over to an adjacent cell if that cell is occupied. Delete the
content of these cells (once you are sure it is nothing of use) and your
titles shouldflow across.

--
Ian
--
"JDN" wrote in message
...
Hi,

Have an Excel report generated by MYOB (small bus accounting package).
The
first few columns should format the chart of accounts using a 'tree'
structure.

The issue is that the text is these cells doesn't display past the RHS
cell
boundary. i.e. rather than running over into the adjacent cell, the
display
is truncated at the rhs cell boundary.

I want this:
Assets
Current Assets
Bank Accounts
Wachovia Checking Account

I get this:
Ass
Curr
Bank
Wachovia Checking Account

How do I tell Excel to allow the text in the first three columns to
display
in their entirety?

Thanks,
JD