How to print grid lines in Microsoft Excel and Google Sheets

By default, Microsoft Excel and Google Sheets are set to show the spreadsheet's grid lines, but not print them. To print the grid lines in a Microsoft Excel or Google Sheets spreadsheet, select a link below and follow the instructions.

Microsoft Excel print grid lines with data

1. Open the Excel spreadsheet containing the data you want to print.
2. Highlight the cells containing the data you want to print.
3. In the Ribbon, on the Home tab, in the Font section, click the down arrow next to Bottom Border.
4. Select the All Borders option.

5. If there is a lot of information in your spreadsheet, you might need to adjust the page breaks accordingly.
6. Click File, then click Print, and then click the print icon to print the graph.

Microsoft Excel print grid lines only

1. Open a blank Excel spreadsheet.
2. Adjust the cells to the preferred dimensions. To do this, click the corner arrow to select all squares on the spreadsheet (1). Then, click and hold between rows B and C, and adjust the cells to the desired width (2). Lastly, click and hold between rows 2 and 3, and adjust the cells to the desired height (3). See the video demonstration below for the steps.

3. In the Ribbon, click the View tab.
4. Click Page Break Preview. Dotted lines are displayed in your spreadsheet, outlining where the pages are currently set up to print (shown below). These lines will not print; they are a guide for where the page breaks are set up.

5. Highlight the cells you want to print.
6. In the Ribbon, click the Home tab.
7. In the Font section, click the down arrow next to Bottom Border.
8. Select the All Borders option.

9. Click File, then Print, and then click the print icon to print the grids.

Google Sheets print grid lines with data

1. Open the Google Sheets spreadsheet containing the data you want to print.
2. Highlight the cells containing the data you want to print.
3. In the editing toolbar near the center, click Borders.
4. Select the All Borders option.

5. Click File, then click Print.

Google Sheets print grid lines only

1. Open a blank Google Sheets spreadsheet.
2. Highlight the cells that contain the grid lines you want to print.
3. In the editing toolbar near the center, click Borders.
4. Select the All Borders option.

5. Click File, then click Print.