Printing Gridlines

Microsoft Microsoft office excel 2007 ac...
March 12, 2010 at 06:29:20
Specs: Windows XP
When printing w/gridlines in Excel, the lines are actually off center. The gridlines are actually going through some of the data. Any advice?

See More: Printing Gridlines

Report •

March 12, 2010 at 08:01:32
Most printers have a diagnostic function where you can recalibrate your printer, see if that helps, also you might want to download the latest drivers for your printer.

Or you could try putting borders around all your cells, see here:


Report •

March 12, 2010 at 09:42:46

I assume that you have sized the columns so that all the data fits in the cells.

Does the screen view look OK

- and is this something new that has just started happening - was printing with gridlines OK in the past.


Report •

March 12, 2010 at 11:36:20
Yes columns were sized, it looks great on the screen, and has just recently started. It doesn't do it for every print job.

Report •

Related Solutions

March 12, 2010 at 11:41:15
Is this an HP printer? if so try this. Go to Start, Printers and Faxes and open up that window. Right click on the printer and select properties. Click on the Device settings tab and look for an option that has something to do with extra/extended printing options. Sorry I can't for the life of me remember what it is called right now. If this option is turned on, turn it off.
For some reason this messes with the formatting of Excell columns

Report •

March 30, 2010 at 06:38:43
Comment from THX 1138 helped me resolve this issue. I am printing to an HP 4100. Start > Printers and Faxes > right click on Printer and select Properties > on General tab, click Printing Preferences > click Advanced > under Document Options see 'Advanced Printing Features' and set to Disabled. Apply the changes and reprint and prinout is formatted correctly. Appreciate the help.

Report •

Ask Question