Excel gridlines

When I open a new worksheet, all the columns and rows gridlines display on the screen but when I print it doesn't show. My question is when I copy from cells to cells those display gridlines disappear so it hard to see a line across. Is there a way to show the view gridlines online but when printing it didn't print the gridlines.

A good example is the form that I filled out the question to you. all the cells in the boxes such name, email were blank. And outside these boxes it shows borders but when didn't when print it out.

Thank you,
Tuan

goto File -> Page Setup -> Sheet (tab) and check 'gridlines' in the 'print' category...

that it?

neo

If printing out a sheet from a webpage also failed to produce lines, then excel is probably not the problem. You can check to see if excel is trying to print gridlines by going File-->Print Preview, and on the print preview screen clicking on the "setup" button. Click on the "sheet" tab. There is a check box under the "Print" heading for "gridlines". If the box is checked, then excel is trying to print gridlines.

If the problem is not related to excel, my first suspicion is a bad printer driver. Try deleting the printer from the printers folder (under Start-->settings-->printers) reboot, and reinstall the driver, or get a new one off of the web. If that doesnt work, then maybe it is the printer or the printer cable. Try switching out components (cables, printers) with known functioning systems to see if you can isolate the problem.
Good Luck!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

gridlines

Re: gridlines

Probably not excel's fault