View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Borders Disappear When Hiding Columns

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" skrev i meddelelsen
...
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