Can't print diagonal borders although they show on print preview

E

Excel-lover

We prepared a spreadsheet and we decided to use diagonal borders on the
angled titles. Although we can see them on Print Preview, the borders won't
print. Please help!
 
D

David McRitchie

Hi ...,
If you print gridlines, the gridlines will not be angled
File, Page Setup, Sheet, [x] print gridlines

But if you have borders, the borders will be angled
select all cells Ctrl+A (ctrl+shift+spacebar plus bitter words if you have 2003)
then use the borders toolbar dropdown or use format, cells, borders
 
E

Excel-lover

David McRitchie said:
Hi ...,
If you print gridlines, the gridlines will not be angled
File, Page Setup, Sheet, [x] print gridlines

But if you have borders, the borders will be angled
select all cells Ctrl+A (ctrl+shift+spacebar plus bitter words if you have 2003)
then use the borders toolbar dropdown or use format, cells, borders

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Excel-lover said:
We prepared a spreadsheet and we decided to use diagonal borders on the
angled titles. Although we can see them on Print Preview, the borders won't
print. Please help!
Click to expand...
Click to expand...
 
E

Excel-lover

Thank you, David, but our problem involves only the titles, which is in Row
1. We angled the titles, then went to Format>Cells>Borders and clicked on
the Left Vertical border and the diagonal (left to right) border to match the
angled titles. They look nice on the screen but when we try to print it,
only the titles show; the diagonal borders won't print. That is our problem.
 
G

Gord Dibben

David

I have an aberrant installation of Excel 2003.

CTRL + A(once) will select all.


Gord Dibben Excel MVP

Hi ...,
If you print gridlines, the gridlines will not be angled
File, Page Setup, Sheet, [x] print gridlines

But if you have borders, the borders will be angled
select all cells Ctrl+A (ctrl+shift+spacebar plus bitter words if you have 2003)
then use the borders toolbar dropdown or use format, cells, borders

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Excel-lover said:
We prepared a spreadsheet and we decided to use diagonal borders on the
angled titles. Although we can see them on Print Preview, the borders won't
print. Please help!
Click to expand...
Click to expand...
 
D

David McRitchie

Why not select all cells, all borders.
What did you see in Print Preview -- I hate wasting paper and ink...
It is the bottom that is angled.
 
R

RagDyer

All you have to do is format the borders to"outline" the cells with any type
of line.

*DON'T* use any diagonals!

Simply create a rectangular perimeter around each cell, and the 45 degree
orientation will take care of the rest.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top