✦Template Printable Ideas Insights

How to Print Excel Spreadsheet with Gridlines

By

When it comes to presenting data from Excel, sometimes you need to print your worksheet in a way that preserves the gridlines. This can be particularly useful for sharing worksheets that have been thoroughly formatted, or when you want to emphasize the structure of your data. In this guide, we'll explore how to print Excel with gridlines, using both Microsoft Excel and Google Sheets.

Before diving into the steps, ensure that your gridlines are visible in the first place. By default, Excel and Google Sheets hide gridlines to keep worksheets clean and uncluttered. Let's start by learning how to turn these gridlines on.

Enable Gridlines in Excel and Google Sheets

Both Excel and Google Sheets allow you to enable gridlines. Here's how:

an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
a green background with the words print blank grid lines and an arrow pointing to it
a green background with the words print blank grid lines and an arrow pointing to it
Excel Worksheet Printing Tips - Printing Problem Fixes
Excel Worksheet Printing Tips - Printing Problem Fixes

In Excel: The fastest way is to press Ctrl + Shift + * (Windows)/Cmd + Shift + * (Mac). Alternatively, you can right-click and select Format Cells, then tick Gridlines under Border.

Excel Gridlines Visibility by Cell Selection

If you want to see gridlines only around selected cells, follow these steps:

How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to print gridlines with Excel 2013
How to print gridlines with Excel 2013
How to print gridlines in Excel
How to print gridlines in Excel

1. Select the cells where you want to see gridlines.

2. Go to the Home tab.

3. Click on Format in the Styles group.

How to Print Gridlines in Excel - A Step-By-Step Guide
How to Print Gridlines in Excel - A Step-By-Step Guide
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to print blank worksheet with gridlines in Excel?
How to print blank worksheet with gridlines in Excel?
How to Print Gridlines in Excel
How to Print Gridlines in Excel

4. Choose Format as Table, and then click OK.

5. Right-click the selected cells and choose Table Properties.

6. Check the Banding circle to show gridlines only around the selected cells.

Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

Google Sheets Gridlines Visibility

Google Sheets also allows you to turn your gridlines on or off. To do this:

1. Open your Google Sheet.

2. Click on View in the menu.

3. Check Show > Gridlines to enable them, or uncheck it to hide them.

Now that you know how to enable gridlines, let's dive into printing your worksheet with gridlines.

Print Excel with Gridlines

Printing Excel with gridlines is a straightforward process. Here are the steps:

Printing Gridlines in Excel

1. Open your Excel worksheet.

2. Click the File tab, and then click Print.

3. In the Print view, ensure that the Print active sheets option is selected.

4. Customize your print settings, such as the print range and page orientation, if needed.

5. Click the Print button or press Ctrl + P to start printing. Your gridlines should now appear on the printed page.

Printing Gridlines in Google Sheets

Google Sheets doesn't provide a direct way to print gridlines, but you can take a screenshot of your worksheet or use a workaround with the Print Layout feature. Here's how:

1. Open your Google Sheet.

2. Click on View in the menu, then click Print Layout.

3. In the Print Preview window, click Print or use Ctrl + P. The gridlines should now appear on the printed page.

Printing gridlines in Google Sheets can sometimes result in white space issues, so consider using the techniques above to achieve the most accurate results.

Printing your Excel worksheet with gridlines allows you to present your data in a clear and well-structured manner. With these steps, you can effectively print gridlines in both Excel and Google Sheets. Keep experimenting with the printing options to find the layout that best suits your needs!