Excel 2003 Bug with Hiding all unused Rows/Columns?

  • Thread starter Thread starter XP User
  • Start date Start date
X

XP User

Running Office 2003 on XP SP1...

If I have a simple spreadsheet that goes from A1 to K20 (small) and I
want it to look neat - I hide all the other columns and rows in the
spreadsheet. The problem is that when I do that - there is an
apparent display bug that the last viewable column has the first 1/2"
of space show up as not having a bottom border. If you scroll down/up
it fixes itself, but if you scroll from the first columns over to the
right most one - you'll see it.

SOrt of looks like this:

| _________ (missing the first part of the bottom left side of
the line)

It's reproducable by making a simple spreadsheet that has more columns
than viewable in a single screen and then you scroll to the right to
see the rest... It also doesn't go away no matter how you change the
border settings.

Any insight on this?
 
I have no insight on this at all, but maybe you could just keep row 21
visible--but make it really small.
 
Hi,

I have seen the identical behavior on Excel 2K and 97. It makes the
sheet look a little untidy and possibly confusing, but as it doesn't
cause any performance problems I didn't look for a solution.

A related point to note is that if you have commented cells on the
right side of the sheet, you need to move the comment boxes onto the
visible section of the sheet to avoid the "Cannot shift objects off
sheet." error.

Good luck finding a solution to the cell format.
 
Back
Top