Prev: Workbooks.OpenText Method / FieldInfo
Next: summing cells in different sheets
From: EricG on 4 Jan 2010 10:55
I have a worksheet on which I have hidden most of the rows (1-2000 still
show) and most of the columns (A-H still show). When I format the borders of
the "showing" cells, the borders in column H do not appear - the cells remain
all white with no borders showing. If I unhide the hidden columns to the
right of column H, the borders in column H show up normally. There is no
conditional formatting of any kind on this sheet.

Has anyone seen this behavior before, and do you understand why it's
happening?

I'm still stuck with Excel 2003 and Windows XP here at work.

Thanks,

Eric

From: EricG on 4 Jan 2010 11:04
Sorry - wrong group. I'll repost in the General Questions area...

"EricG" wrote:

> I have a worksheet on which I have hidden most of the rows (1-2000 still
> show) and most of the columns (A-H still show). When I format the borders of
> the "showing" cells, the borders in column H do not appear - the cells remain
> all white with no borders showing. If I unhide the hidden columns to the
> right of column H, the borders in column H show up normally. There is no
> conditional formatting of any kind on this sheet.
>
> Has anyone seen this behavior before, and do you understand why it's
> happening?
>
> I'm still stuck with Excel 2003 and Windows XP here at work.
>
> Thanks,
>
> Eric
>
From: Per Jessen on 4 Jan 2010 12:18
Hi Eric

Select column H and format cells with a right side border, or in first
unused column (first visible column) insert a left border.

Hopes this helps.
.....
Per

"EricG" <EricG(a)discussions.microsoft.com> skrev i meddelelsen
news:2F97B66F-9F87-47DD-8F6A-08A9E514AA13(a)microsoft.com...
>I have a worksheet on which I have hidden most of the rows (1-2000 still
> show) and most of the columns (A-H still show). When I format the borders
> of
> the "showing" cells, the borders in column H do not appear - the cells
> remain
> all white with no borders showing. If I unhide the hidden columns to the
> right of column H, the borders in column H show up normally. There is no
> conditional formatting of any kind on this sheet.
>
> Has anyone seen this behavior before, and do you understand why it's
> happening?
>
> I'm still stuck with Excel 2003 and Windows XP here at work.
>
> Thanks,
>
> Eric
>

 | 
Pages: 1
Prev: Workbooks.OpenText Method / FieldInfo
Next: summing cells in different sheets