 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / July 2008My borders/grids show on print preview, but won't print?
Hello, I've been pulling my hair out for 2 days about this problem, and cannot find a way to solve it. So ANY help would be greatly appreciated! When I pull up an Excel Spreadsheet that I have been using for 5 years, the entire area has All borders on it. So, that it appears with each line, and each column seperated. Okay, the borders show on my spreadsheet, they show when I got to Print Preview, However; when I click print, the paper comes out, and NONE of my borders on on it?? The words are, column headers, etc., numbers on the left of each line, But NO Borders?? It's now doing this on every single excel document that I have that shows borders on it. None Print out!?! PLEASE if anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. I've had a couple users with this problem too. It seemed to vary depending on the printer they used i.e. when they printed it on a bigger more expensive printer it came out normally > Hello, I've been pulling my hair out for 2 days about this problem, and > cannot find a way to solve it. So ANY help would be greatly appreciated! [quoted text clipped - 8 lines] > document that I have that shows borders on it. None Print out!?! PLEASE if > anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. Having some trouble understanding the phrasing of your question...can you please redefine the following part? "has All borders on it."...Do you mean the gridlines are Black or visible? "So, that it appears with each line, and each column seperated."...separated by what? Lines or empty columns? Sorry not getting the question....try again. > Hello, I've been pulling my hair out for 2 days about this problem, and > cannot find a way to solve it. So ANY help would be greatly appreciated! [quoted text clipped - 8 lines] > document that I have that shows borders on it. None Print out!?! PLEASE if > anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. "has All borders on it."...Do you mean the gridlines are Black or visible? **Meaning, that YES all the Borders are black and visible, just as they should be. "So, that it appears with each line, and each column seperated."...separated by what? Lines or empty columns? **Seperated by LINES, The Borders that are set in my spreadsheet. **Everything shows up perfectly when I pull up my spreadsheet by double clicking on it, it even looks correct when I do a Print Preview, but when I click on Print, the paper that comes out of my printer ONLY has TEXT on it, It's all located in the right places, but there are NO lines/borders/gridlines at all on the printed document! Thanks > Having some trouble understanding the phrasing of your question...can you > please redefine the following part? [quoted text clipped - 18 lines] > > document that I have that shows borders on it. None Print out!?! PLEASE if > > anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. Yep, agree, printer issue, drivers probably. You can always try cutting and pasting your data into a new workbook, save it, set up the page again, and see if a new workbook solves the issue, that is assuming that the file used to print just fine from the same printer in the past. Quirky. > "has All borders on it."...Do you mean the gridlines are Black or visible? > [quoted text clipped - 35 lines] > > > document that I have that shows borders on it. None Print out!?! PLEASE if > > > anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. I disagree. I am having the same problem which is driving me and my associates crazy. Any thick borders print just fine, the standard size borders will not. In order to get all the borders to print we have to do one of the following things: 1: go to print preview and either turn margins on or off, then print. 2: select a cell, then go to borders, cancel out back to the spreadsheet, then print. 3: go to print preview, zoom in on the document, then zoom back out, then print. 4: Save and close the document and reopen it, then print. I know none of these solutions should have anything to do with getting the borders to print, and they sound completely rediculous, but for some reason doing one of these actually works.... Sometimes. > Yep, agree, printer issue, drivers probably. > [quoted text clipped - 42 lines] > > > > document that I have that shows borders on it. None Print out!?! PLEASE if > > > > anyone can help me, this is SO aggravating! Sincerely, Candace/shawsec. I have been having issues with this myself and found that if I don't set the print area the grid lines will print.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.