Extend visible cell text over adjacent cell

  • Thread starter Thread starter paulkaye
  • Start date Start date
P

paulkaye

Apologies if this has been answered previously but I don't even know
what to search for!

If I type a long string into a cell (without wrap checked), the cell
contents will be displayed in full if the cell(s) to the right are
empty. However, if they contain information, the first cell's contents
are visible only up to the border of the two cells. This makes sense
under normal circumstances.

I am looking for a way to enforce this first overlapping behaviour.
The adjacent cell contains important info but does not need to be
seen. In fact, I have made the font white so that it is invisible.

Any ideas?!?
 
No can do unless you delete the data in the cell. Why not just widen or add
a column?
 
I'm not a fan, but if you can't find anything else, you could add cell
comment or data validation.

Again, it's the last thing to consider.
 
If it doesn't need to be seen ... HIDE IT!

As long as the rest of the adjoining columns are empty, your text will
extend into those visible, adjoining columns, going right past the hidden
column(s).
 
Hi all,

Thanks for your ideas. I've hidden quite a lot in this document but
that only works for entire rows and columns. It would take ages to
explain WHY I need to do this very awkward thing but I do! The idea I
described would have been perfect but if it's not possible, I'll have
to reshuffle the page and do some hiding.

Thank you all again,

Paul
 
Back
Top