If you want to print the gridlines and row and column headings in Excel, there are a few different ways to do it. The easiest way is to use the Print Preview feature in Excel. Just select the cells that you want to print, and then click the Print button on the toolbar. If you don’t have access to the Print Preview feature, you can also use the Gridlines command on the Home tab of Excel. This command will automatically print all of the gridlines in your spreadsheet. You can also use this command to print just the row or column headings, if you want. whichever method you choose, be sure to keep in mind that printing in Excel can be a bit slow depending on your computer configuration. ..
Gridlines and the row and column headings can be helpful when viewing data on worksheets printed in Excel. We’ll show you how to turn on a couple of settings to show the gridlines and row and column headings on your printed worksheets.
Print Gridlines
Open the workbook and select the worksheet for which you want to print the gridlines. Click the “Page Layout” tab.
NOTE: This option is specific to each worksheet in your workbook.
In the “Sheet Options” section, select the “Print” check box under “Gridlines” so there is a check mark in the box.
The “Print Gridlines” option applies only to the current workbook and is set separately for each worksheet in your workbook. The state of the option (on or off) for each worksheet is saved with the workbook.
You can also change the color of the gridlines.
Print Row and Column Headings
By default, Excel doesn’t print the row and column headings you see on the screen. However, you can choose to do so.
Open the desired workbook and click the tab at the bottom for the worksheet for which you want to print row and column headings.
Click the “Page Layout” tab, if it’s not already the active tab.
In the “Sheet Options” section, select the “Print” check box under “Headings” so there is a check mark in the box.
Just like the “Print Gridlines” option, the “Print Headings” option only affects the currently active worksheet in the current workbook. To print row and column headings for other worksheets in your workbook, select each worksheet and turn on this option.
Troubleshooting
If gridlines don’t appear in the print preview or the resulting printout, you probably have the “Draft quality” enabled for your printer. This mode is designed to save ink, so it omits things like the gridlines.
To disable this option, click File > Print > Page Setup in Excel. Click the “Sheet” tab. If “Draft quality” is checked here, uncheck it and click “OK.”
