Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Excel-lover
 
Posts: n/a
Default

Thank you, David, but our problem involves only the titles, which is in Row
1. We angled the titles, then went to FormatCellsBorders 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.

"Excel-lover" wrote:

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!

  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

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.


"Excel-lover" wrote...
Thank you, David, but our problem involves only the titles, which is in Row
1. We angled the titles, then went to FormatCellsBorders 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.




  #3   Report Post  
RagDyer
 
Posts: n/a
Default

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!
==============================================


"Excel-lover" wrote in message
...
Thank you, David, but our problem involves only the titles, which is in

Row
1. We angled the titles, then went to FormatCellsBorders 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.

"Excel-lover" wrote:

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot print gridlines in worksheet even tho they show on screen papadip Excel Discussion (Misc queries) 3 June 6th 05 03:42 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
EXCEL - Cannot print borders in color(s) I have selected Mark M Excel Discussion (Misc queries) 0 January 18th 05 03:25 PM
Our Excel 2000 won't let us print watermarks-they don't show up &. SparkleTX Excel Discussion (Misc queries) 1 December 15th 04 10:41 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 04:33 PM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"