![]() ![]() ![]() (Apologies that the attachments are embedded - I couldn't find any option other than 'in line'. This can be seen in the pairs PrintArea1.jpg and borders1.pdf and PrintArea2.jpg and borders2.pdf.Īny idea how to turn the outer border off? ![]() I have always been able to select a print area that is one row and one column wider than the table itself, and this printout has had a single border, as intended.īut lately I am getting a double border when the print area includes these extra rows and columns - so clearly there is a 'page border' command somewhere that is switched on. The outermost cells of the table have a genuine border around them that I have placed there using cell formatting.įor historical reasons there is a zone of rows and narrow colums around the table this can be seen in the screenshot. I went down 40 lines and entered column names there and when I went to print preview it showed the gridlines so I clicked on print and it printed the gridlines. ![]() Workaround 1: Change the border style For borders, using any border format other than the default style enables correct printing in Normal printing mode. This might occur in Normal or Draft printing mode in Windows 8 and 7. The spreadsheet itself is shown in the screenshot Spreadsheet.jpg. The file I was trying to print had only one live of print, column names. Steps to Print Gridlines in Excel Go to the Page Layout tab and check the option Print inside the Sheet Options box on the right of the Ribbon menu: Hit Ctrl. When printing an Excel (2013 or 2010) spreadsheet with gridlines or default borders (style 2), not all horizontal lines print. If you cancel that selection, youll be able to use the check boxes. Note: If the check boxes in the Sheet Optionsgroup appear dimmed, it may be because you have a chart, image, or other object selected on the worksheet. I am having a problem removing an outer border that has begun to appear on printouts (pdf and hard copy) of a spreadsheet. 5 Reasons & Solutions for Missing Gridlines in Excel When Printing 1. On the Page Layouttab, in the Sheet Optionsgroup, select the Printcheck box under Gridlines. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |