Cell borders do not print on one side of print area??

  • Thread starter Thread starter alan82
  • Start date Start date
A

alan82

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


| 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
 
Borders can be a bit odd. As a guess your have right had borders are actually
left hand borders of the cells to the right. In that case unless you include
the cells immediately to the right that contain the borders you will not get
your border. To fix the problem remove the borders from the right hand side
and replace them with right hand borders of the appropriate cells.
 
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


| 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
Click to expand...

Perfect! Thanks,
 
Back
Top