View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Homey Homey is offline
external usenet poster
 
Posts: 143
Default Cell borders do not print on one side of print area??

border must belong to cell in print area.

try this test to see problem

new sheet, put somethng in A1
set print area to A1 only - imoportant to do this for test!
goto B1 and give left border
do print preview - no border!

now do same again but give right border to A1.

with your sheet you must remove the bad bordr and add new right border


"alan82" wrote in message
...
| Hi all,
|
| I am having problems printing a spreadsheet in Excel 2003 SP3.
|
| The cell borders do not print on the RHS of right most column in the
| print area. The top, bottom and LHS of the print area are ok. I have
| checked the properties of those cells in the right most column and
| they show the correct border settings. But, the borders do not show up
| on the Print Preview.
|
| any ideas??
|
| Thanks in advance for your time!
|
| A