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

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
 
H

Homey

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
 
J

Jim Thomlinson

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

alan82

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

Perfect! Thanks,
 

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