Hi,

I'm using Excel 2003 and I have a spreadsheet which I have set up so that
'gridlines', 'black and white' and 'draft' are unchecked. The cells where
information is to be entered have black borders.

When I select print preview, most of the cells are fine but there are 5 rows
where the borders aren't showing at all. They're not even together, they're
throughout the spreadsheet!

I've tried manually drawing each border, I've tried changing the colour but
it doesn't seem to work.

Does anyone have any ideas?

Thanks in advance

Claire

Hi Claire,

It sounds like you're experiencing an issue where some of the borders in your Excel spreadsheet aren't appearing in print preview. This can be frustrating, but there are a few things you can try to fix the problem.

Here are some steps you can take:

1. Check your page setup: Make sure that your page setup is set to print gridlines and borders. To do this, go to File Page Setup Sheet tab and make sure that the "Gridlines" and "Black and white" options are unchecked, but the "Draft quality" option is checked.
   
2. Check your print area: Make sure that your print area is set up correctly. To do this, go to File Print Area Set Print Area. Make sure that the cells with borders are included in the print area.
   
3. Check your printer settings: Make sure that your printer settings are set up correctly. Go to File Print and click on the "Properties" button next to your printer. Make sure that the "Print Quality" setting is set to "High" and that the "Borderless Printing" option is unchecked.
   
4. Try a different printer: If none of the above steps work, try printing your spreadsheet on a different printer. Sometimes, certain printers can have issues with printing borders.

I hope these steps help you resolve the issue with your borders not appearing in print preview. Let me know if you have any other questions!

Hi,

Just a thought, have you actually printed it off, or are you just looking at
print preview. As sometimes when I look at print preview I can't see the
borders on things, but if I zoom in I can see the borders and when I print it
off the borders are there.


"Claire" wrote:

Hi,

I'm using Excel 2003 and I have a spreadsheet which I have set up so that
'gridlines', 'black and white' and 'draft' are unchecked. The cells where
information is to be entered have black borders.

When I select print preview, most of the cells are fine but there are 5 rows
where the borders aren't showing at all. They're not even together, they're
throughout the spreadsheet!

I've tried manually drawing each border, I've tried changing the colour but
it doesn't seem to work.

Does anyone have any ideas?

Thanks in advance

Claire

And those borders show up when you're just looking at the worksheet, right?

Just a guess...

I'd try a different printer/printer driver.


Claire wrote:

Hi,

I'm using Excel 2003 and I have a spreadsheet which I have set up so that
'gridlines', 'black and white' and 'draft' are unchecked. The cells where
information is to be entered have black borders.

When I select print preview, most of the cells are fine but there are 5 rows
where the borders aren't showing at all. They're not even together, they're
throughout the spreadsheet!

I've tried manually drawing each border, I've tried changing the colour but
it doesn't seem to work.

Does anyone have any ideas?

Thanks in advance

Claire

--

Dave Peterson

Yup it does actually print fine!

*sigh* its always a simple answer

Thanks for your help!

"Sam H" wrote:

Hi,

Just a thought, have you actually printed it off, or are you just looking at
print preview. As sometimes when I look at print preview I can't see the
borders on things, but if I zoom in I can see the borders and when I print it
off the borders are there.


"Claire" wrote:

Hi,

I'm using Excel 2003 and I have a spreadsheet which I have set up so that
'gridlines', 'black and white' and 'draft' are unchecked. The cells where
information is to be entered have black borders.

When I select print preview, most of the cells are fine but there are 5 rows
where the borders aren't showing at all. They're not even together, they're
throughout the spreadsheet!

I've tried manually drawing each border, I've tried changing the colour but
it doesn't seem to work.

Does anyone have any ideas?

Thanks in advance

Claire