Problem with printing a border in Excel 2007


D

dlf

I have a worksheet where the right hand most column has a bold border on its
right hand side. The column is shaded. It appears fine, but when I go to
print the worksheet (highlighting the cells and telling it to "print
selection," one cell in that column is missing its right hand border.

I've tried adding one more column to the right in the selection but it
doesn't help. I've tried deleting the row and then typing the contents back
in, but that doesn't help either. Help please!
 
Ad

Advertisements

D

dlf

Sorry... I discovered it was a simple problem of the words in that one cell
trying to flow over to the cell on the right (even though it appeared to be
fine while in the worksheet itself--the problem only appearing when I viewed
it in "Page Break Preview" or when it was actually printed). The simple
solution - widen the column. I figured it was something simple. Dumb!
 
B

Bill Sharpe

dlf said:
I have a worksheet where the right hand most column has a bold border on its
right hand side. The column is shaded. It appears fine, but when I go to
print the worksheet (highlighting the cells and telling it to "print
selection," one cell in that column is missing its right hand border.

I've tried adding one more column to the right in the selection but it
doesn't help. I've tried deleting the row and then typing the contents back
in, but that doesn't help either. Help please!

Try right-clicking the affected cell, select Format. On the Format
dialog box select Borders. Check to see whether there's a border for the
right vertical side.

Does print preview show a border for this cell?

Bill
 
Ad

Advertisements

D

dlf

Thanks Bill. Yes, I had tried checking the format on that one cell and the
border was there. It only disappeared once I tried to "print preview" the
worksheet. But it was, as I say, a simple problem of the text content being
too wide, so when I increased the column width, everything was fine. I
repeat: "Dumb" on my part! I thought I had tried everything. Thanks for your
help.
 

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