overwriting adjacent cells
 

Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into the 1st
column (column A) it displays fully as it overlaps the ajacent columns
B,C.... which are empty.

If I enter anything at all into column B, even the null character, or an IF
function which evaluates to null, the text string is truncated to the width
of column A.

Is there any way of getting the text to overlap adjacent columns if their
cells are null ?

( I am aware of the wrap and rotate options, but they would require a large
row height.)

Thanks for all ideas

K

overwriting adjacent cells
 

Increase column width or wrap...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into the
1st column (column A) it displays fully as it overlaps the ajacent columns
B,C.... which are empty.

If I enter anything at all into column B, even the null character, or an
IF function which evaluates to null, the text string is truncated to the
width of column A.

Is there any way of getting the text to overlap adjacent columns if their
cells are null ?

( I am aware of the wrap and rotate options, but they would require a
large row height.)

Thanks for all ideas

K

overwriting adjacent cells -thanks but
 

Hello & thanks, but sorry you missed the point. My fault for not explaining
it fully.

The columns are narrow because they need to be narrow, there are an awful
lot of them. The cells contain IF functions, a few of which evaluate to a
text string, most evaluate to null. I just want to see as much of the text
as possible.

Sorry for the confusion.

K


"Don Guillett" wrote in message
...
Increase column width or wrap...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into the
1st column (column A) it displays fully as it overlaps the ajacent
columns B,C.... which are empty.

If I enter anything at all into column B, even the null character, or an
IF function which evaluates to null, the text string is truncated to the
width of column A.

Is there any way of getting the text to overlap adjacent columns if their
cells are null ?

( I am aware of the wrap and rotate options, but they would require a
large row height.)

Thanks for all ideas

K

overwriting adjacent cells -thanks but
 

If there is anything in the column to the right including a touch of the
space bar, you will not see it unless you widen or wrap. Do you want a macro
to do that?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello & thanks, but sorry you missed the point. My fault for not
explaining it fully.

The columns are narrow because they need to be narrow, there are an awful
lot of them. The cells contain IF functions, a few of which evaluate to a
text string, most evaluate to null. I just want to see as much of the text
as possible.

Sorry for the confusion.

K


"Don Guillett" wrote in message
...
Increase column width or wrap...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into the
1st column (column A) it displays fully as it overlaps the ajacent
columns B,C.... which are empty.

If I enter anything at all into column B, even the null character, or an
IF function which evaluates to null, the text string is truncated to the
width of column A.

Is there any way of getting the text to overlap adjacent columns if
their cells are null ?

( I am aware of the wrap and rotate options, but they would require a
large row height.)

Thanks for all ideas

K

overwriting adjacent cells -thanks again
 

OK, thanks, that's pretty much what I'd figured.

Thanks for the offer of a macro, but not for now. I think there might be a
way out of my problem by using comments.

Thanks again

K


"Don Guillett" wrote in message
...
If there is anything in the column to the right including a touch of the
space bar, you will not see it unless you widen or wrap. Do you want a
macro to do that?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello & thanks, but sorry you missed the point. My fault for not
explaining it fully.

The columns are narrow because they need to be narrow, there are an awful
lot of them. The cells contain IF functions, a few of which evaluate to a
text string, most evaluate to null. I just want to see as much of the
text as possible.

Sorry for the confusion.

K


"Don Guillett" wrote in message
...
Increase column width or wrap...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into
the 1st column (column A) it displays fully as it overlaps the ajacent
columns B,C.... which are empty.

If I enter anything at all into column B, even the null character, or
an IF function which evaluates to null, the text string is truncated to
the width of column A.

Is there any way of getting the text to overlap adjacent columns if
their cells are null ?

( I am aware of the wrap and rotate options, but they would require a
large row height.)

Thanks for all ideas

K

overwriting adjacent cells -thanks again
 

Hello, KRK did you found out the way to solve your problem. I am sure this
can be done.
I face an oppsite problem, one of the sheet work all cell contents can not
carries over to the adjacent cells. I dont' know how this happen, but that's
what you want.


"KRK" wrote:

OK, thanks, that's pretty much what I'd figured.

Thanks for the offer of a macro, but not for now. I think there might be a
way out of my problem by using comments.

Thanks again

K


"Don Guillett" wrote in message
...
If there is anything in the column to the right including a touch of the
space bar, you will not see it unless you widen or wrap. Do you want a
macro to do that?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello & thanks, but sorry you missed the point. My fault for not
explaining it fully.

The columns are narrow because they need to be narrow, there are an awful
lot of them. The cells contain IF functions, a few of which evaluate to a
text string, most evaluate to null. I just want to see as much of the
text as possible.

Sorry for the confusion.

K


"Don Guillett" wrote in message
...
Increase column width or wrap...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
Hello, I have Excel 2007

I have a sheet with rather narrow columns.

Starting with a blank sheet,... if I enter a long text string into
the 1st column (column A) it displays fully as it overlaps the ajacent
columns B,C.... which are empty.

If I enter anything at all into column B, even the null character, or
an IF function which evaluates to null, the text string is truncated to
the width of column A.

Is there any way of getting the text to overlap adjacent columns if
their cells are null ?

( I am aware of the wrap and rotate options, but they would require a
large row height.)

Thanks for all ideas

K