As a last resort, you can apply borders around the cells that you want to print.
In this case, you can try downloading the latest driver from the printer manufacturer's website. If gridlines still don't print successfully, there may be an issue with your printer driver. For a shortcut to access the Page Setup dialog box, press Alt+P, S, P. The Draft quality check box appears on Sheet tab in the Page Setup dialog box. To see or print the gridlines for these cells, remove the fill color by selecting the cells, and then click the arrow next to Fill Color ( Home tab, Font group), and To remove the fill color, click No Fill. Troubleshoot printing issues with gridlines – If gridlines don't show up when you print your worksheet, or if you can't see them in the Print Preview window, check that the Draft quality check box is not selected. If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. To learn more about these options, see Define or clear a print area on a worksheet or Apply or remove cell borders on a worksheet. Or, you can apply borders around the cells instead. If you want to print gridlines around empty cells also, you must set the print area to include those cells. Some people use it because they don’t realise you can turn off gridlines see the View ribbon tab. It is caused by the White Fill colour, which clears the grey gridlines. Gridlines print only around actual data in a worksheet. If you have seen something like the image below and wondered what is going on, the answer is a Fill colour. Preview the gridlines – To see how the gridlines will print, press Ctrl+F2 to open the File tab, which displays a preview of printed worksheet. Keyboard shortcut You can also press Ctrl+P.Īfter you select the Print check box, you might want to take the following steps: If you cancel that selection, you'll be able to use the check boxes.Ĭlick the File tab, and then click Print.
In this tutorial, we will go over each of the above cases one by one and show you how to remove dotted lines in Excel (or dashed lines).Note: If the check boxes in the Sheet Options group appear dimmed, it may be because you have a chart, image, or other object selected on the worksheet.
Click and drag your cursor to select all cells that you want to be included in printing. Step 1: In the Ribbon, choose Layout and look for Align. Create a new Excel document Online or open an existing one. This article describes how you can make the gridlines appear in your printed worksheets. By default, gridlines dont appear on a printed Microsoft Excel worksheet or workbook.
There may be a number of reasons you see dotted (or dashed) lines on your Excel screen. Use the following steps to mimic gridlines and print them when using the free Excel Online: Navigate to in your browser. Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. Whatever the case, we will try to tackle it step by step so as to help you find the solution. The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line.