Gridlines problem Excel 2000

C

Chris Bauer

I am trying to print gridlines on a workbook and instead of getting the
gridlines, I am getting a line around the outside of the data, like a text
box frame. I have been using gridlines for quite a long time and never came
across this before. I tried turning the lines off and back on, still the
same, checked the cell formatting, no border is enabled or anything. Anyone
have any ideas?

I also tried copy/pasting the main worksheet into a new workbook and it
works fine. I have data linked to five other worksheets or I would just
leave it in the new workbook.

Thanks!
 
D

Dave Peterson

Any chance you filled the range with a color and then instead of removing that
fill, you changed the fill to white?

Use "no fill" or "no color" instead if that's what happened.
 
E

Ed O'Brien

Hi, Chris.

Have you checked in File||Page Setup and enabled Print//Gridlines?

Hope this helps,

Ed
 
C

Chris Bauer

You know, I don't know how, I only colored in a few cells, but that must
have been it, I removed all shading and it worked! 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

Similar Threads

Faint gridlines 2
Restoring Gridlines 3
Where are my gridlines 1
GRIDLINES 2
Gridlines not printing?! 7
Gridlines disappear 1
copy excel cells to word without gridlines 1
Missing grid lines 1

Top