Then click the Home tab at the top of the window.Ĭlick the arrow to the right of the Borders icon, then click the No Border option.Īre you looking for some helpful ways to make your spreadsheet look better when you print it? Our guide to Excel printing can show you a few tricks that will make your printed worksheets look better, as well as make them easier to read. To remove the borders, click the button at the top-left corner of the spreadsheet to select all of your cells, If you still see lines on your spreadsheet after making this change, then you may actually have borders applied to your spreadsheet, as opposed to gridlines. You can then go to the Print Preview, where you should see that your spreadsheet is set to print without gridlines. Step 3: Uncheck the box to the left of Print under Gridlines in the Sheet Options section of the Office ribbon. Step 2: Click the Page Layout tab at the top of the window. Step 1: Open your spreadsheet in Microsoft Excel 2010. Other worksheets in this workbook will not be affected, as this setting is applied at the worksheet level. Note that the changes that you apply below will only affect the current worksheet in your workbook. The Draft quality check box appears on Sheet tab in the Page Setup dialog box. In the Sheet Options section, select the Print check box under Gridlines so there is a check mark in the box. Why does excel print without gridlines Troubleshoot printing issues with gridlines If gridlines dont show up when you print your worksheet, or if you cant see them in the Print Preview window, check that the Draft quality check box is not selected. NOTE: This option is specific to each worksheet in your workbook.
The steps in this article will assume that your worksheet is currently set to print with gridlines, and that you wish to print the worksheet without them. Open the workbook and select the worksheet for which you want to print the gridlines. Print a Spreadsheet Without Gridlines in Excel 2010 Fortunately this is a setting that you can adjust by following just a few simple steps.
However, many people adjust the settings of their worksheets to include printed gridlines because it can make them much easier to read.īut not every spreadsheet needs gridlines and, depending upon your preferences when using Excel 2010, you may wish to remove them for a spreadsheet that you are printing. A worksheet that you print in Microsoft Excel 2010 will not include gridlines by default.
0 kommentar(er)
