Borders Disappear When Hiding Columns

E

EricG

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
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top