Search This Blog

Monday, May 6, 2013

Fixing Excel borders that won't print


How frustrating to find that the borders that printed yesterday, won't print today.  Here are some possible fixes. Try them until it works!
 
Go to File, Print, Page Setup. On the Sheet tab under Print, check Gridlines and uncheck Draft quality.
Use Roundtripping: Save as HTML, then resave the file as Excel.
Save the file as  Excel 2003.
The border may be on the cell adjacent to the one you think it’s on. Try removing all borders and recreating them within the print area.
Double click the  printer to download a new printer driver.

1 comment:

  1. I didnt even know you could print just the grid. I always had to manually insert cell borders -.- And even for that i had to use a gudie (for the curious: http://www.excel-aid.com/excel-borders-drawing-borders-around-cells-and-cell-ranges.html, dont know if its god as i am kinda new). I feel like a moron now :(

    ReplyDelete