Force text to extend beyond cell boundaries

[joeho]

Is there any way to force Excel to display text beyond cell boundaries?

I have over two hundred columns that are only 5 pixels wide, and
would like to enter a formula in each cell that evaluates to text if
condition is met, and evaluates to "" if not. The problem is that th
text will not display beyond the right boundary of the cell if there i
a formula in the next cell - even if the formula evaluates to "".

For a picture, see: http://www.thezac.com/temp/excel.gif

In the picture, the text only extends beyond the cell because the cell
to the right of it do not contain the formula.

Thanks,

joeh

 

[Frank Kabel]

Hi
if the adjacent cell contains a formula no chance to extend the text
beyond the boundaries

 

[Mark]

I think you might have to insert a Comment using vba that
fills the Comment box with the cells info. When you
mouseover it shows the cells contents.

What are you doing and can it be improved? If you want to
keep it a secret then email me at:
(e-mail address removed)

Semd a sample sheet to me and I might be able to improve
on the original.

regards
Mark
http://au.geocities.com/excelmarksway

 

[joeho]

Hi Mark,

The worksheet is designed to visually represent a schedule of classes
I have a list of classes on one worksheet, and the worksheet that I a
asking about displays a schedule of the classes that have bee
selected.

What I'm trying to do now is display the name of the class in it'
'time block'. It looks like I might have to resort to VBA to populat
the name of the class.

I should note that my goals for this worksheet include learning ne
Excel techniques, not just accomplishing what I set out to do.

If you want to take a look at it, I'd welcome your comments.

The worksheet is a half-meg, so I put it a
http://www.thezac.com/temp/schedule.xls

Please note that the range BJ6:BJ7 on the 'Display worksheet i
different from the other cells. In that section, I moved things aroun
to try to accomodate a formula that would display the text I want t
display.

Also, while I have your attention, I might as well ask if there is
way to create a dynamic filter (or at least get the same effect). M
filter on the 'Schedule' worksheet doesn't update when I 'X' ou
different rows on the 'All Courses' worksheet.

Thanks.

joeh