Border disappears in Print Preview & Print


D

dbagby

I am working in Excel 2007 and I have a spreadsheet that contains various
rows with bold border lines on the top and bottom of each section when I go
to view the sheet in Print Preview the bottom border where the page breaks
the border does not show nor does the top border on the next page.

I went back in to my formatting to make sure that I had selected for both
the top and bottom border sections were selected so I am at a loss. Can
someone help?
 
Ad

Advertisements

J

Jim Rech

If you use Set Print Area (or the range name "Print_Area") the borders have
to belong to cells that are in the print area or they do not appear on the
print out. Example:

-Your print area starts at A10:D10
-If you select A10:D10 and apply Top Borders they will appear in the
printout.
-If you select A9:D9 and apply Bottom Borders they will not appear in the
printout.

So you may have to reapply the borders after selecting the right range.

--
Jim
|I am working in Excel 2007 and I have a spreadsheet that contains various
| rows with bold border lines on the top and bottom of each section when I
go
| to view the sheet in Print Preview the bottom border where the page breaks
| the border does not show nor does the top border on the next page.
|
| I went back in to my formatting to make sure that I had selected for both
| the top and bottom border sections were selected so I am at a loss. Can
| someone 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