![]() Everything works fine except there are four cells in the spreadsheet where the gridlines are significantly darker than is true for all of the other cells. I want the spreadsheet to show gridlines. I've got an Excel 2016 spreadsheet that I am printing using the 'Microsoft Print to PDF' option. If you use Microsoft Office Excel 2003 or Microsoft Excel 2002, follow these steps: Select the cell to which the arrow is pointing. On the Formulas tab, click Remove All Arrows in Formula Auditing group, and then click Remove Precedent Arrows. This helps support the channel and allows us to continue to make videos like this. Excel 2016 - Random Dark Gridlines in PDF. If you use Excel 2007, follow these steps: Select the cell to which the arrow is pointing. ![]() Remove Grid Lines From Sheets and Workbooks You can remove grid lines from individual worksheets, from entire workbooks or from selected sheets in a workbook. Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. Excel doesn't print grid lines by default, so you don't need to do anything if your only reason for removing them is to not show them on print copies. ✉ Not sure which of my Excel courses fits best for you? Take the quiz: Then you'll see dotted lines indicating automatic page breaks. It usually happens when you return to Normal View from a Print Preview or Page Layout. See how to hide gridlines in an Excel worksheet, remove lines in a range of cells and how to show gridlines again. I'll show you how you can get rid of the irritating page breaks lines (dotted lines) in Microsoft Excel.
0 Comments
Leave a Reply. |