If gridlines still don’t print successfully then there may be an issue with your printer driver. To quickly access the Page Setup window, press Alt+ P and then S+ O. The Draft quality checkbox is found on the Sheet tab in the Page Setup window. If gridlines don’t show up when you print your worksheet-or if you can’t see them in the Print Preview window-make sure that the Draft quality checkbox is not selected. 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. Alternatively, you can apply borders around the cells instead. If you want to print gridlines around empty cells as well, you must set the print area to include those cells. Note: Gridlines are designed to print only around actual data in a worksheet. Press Ctrl+ F2 to open the Print Preview window and see how the gridlines will print. Select File > Print (or press Ctrl+ P).If you cancel that selection you’ll be able to use the checkboxes. Note: If the checkboxes in the Sheet Options section of the ribbon are grayed-out, it may be because you have a chart, image, or other object selected on the worksheet. In the Sheet Options section of the ribbon, mark the Print checkbox (under Gridlines). Select the worksheet(s) that you want to print.The steps below explain how you can make the gridlines appear in your printed worksheets. By default, gridlines don’t appear on a printed worksheet or workbook in Excel 2007.
0 Comments
Leave a Reply. |