✦Template Printable Ideas Insights

How to Print Excel Sheet with Gridlines

By

Ever needed to print an Excel sheet with gridlines to maintain that structured look on paper? You're not alone. Gridlines help maintain a clean, organized appearance, making it easier to read and follow data. But how do you accomplish this? Let's dive into how to print Excel sheets with gridlines.

Before we get started, ensure you're using a recent version of Microsoft Excel. The steps outlined here work for Excel 2013 and later, including Excel Online. Now, let's explore the steps to display and print gridlines.

Displaying Gridlines on Your Excel Sheet

Before you can print your gridlines, you need to make sure they're visible on your screen. By default, Excel hides gridlines to reduce clutter, but it's simple to turn them back on.

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
How to print blank worksheet with gridlines in Excel?
How to print blank worksheet with gridlines in Excel?

Here's how to display gridlines:

  1. Open your Excel sheet.
  2. Go to the View tab.
  3. In the Show section, check the box next to Gridlines.

Once you've done that, you should see your gridlines appear on the screen.

Excel Worksheet Printing Tips - Printing Problem Fixes
Excel Worksheet Printing Tips - Printing Problem Fixes
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to Print Gridlines in Excel - A Step-By-Step Guide
How to Print Gridlines in Excel - A Step-By-Step Guide

Changing Gridline Color and Style

In case you want to customize your gridlines, here's how to change their color and style:

1. Right-click anywhere on the sheet.

2. Select Format Cells.

How To Print Gridlines in Excel
How To Print Gridlines in Excel
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
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
Excel Bonus Tip: Print Gridlines for Clearer Reports
Excel Bonus Tip: Print Gridlines for Clearer Reports
how to print large excel sheet in one page
how to print large excel sheet in one page

3. Under Number, choose Custom.

4. In the Format cell, change the Number to [Color] and select your preferred color.

5. In the Font group, choose the Font color of your gridlines.

Excel Worksheet Printing Tips - Printing Problem Fixes
Excel Worksheet Printing Tips - Printing Problem Fixes
Simple To-Do List Setup in Google Sheets for Beginners
Simple To-Do List Setup in Google Sheets for Beginners
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets

Adjusting Gridline Thickness

To change the thickness of your gridlines:

1. Right-click anywhere on the sheet.

2. Select Format Selection (or Range).

3. In the Format Selection panel, under Border, click on the Line Style box.

4. Choose your preferred line thickness.

Printing Excel Sheets with Gridlines

Now that you've got your gridlines just the way you want them, it's time to print your Excel sheet. Here's how:

1. Select the range you want to print, or press Ctrl + A (Windows) or Command + A (Mac) to select the entire sheet.

2. Click on the File tab.

3. Click on Print.

4. In the Print what section, ensure Selection is chosen if you've selected a specific range. Otherwise, leave it on Active Sheets.

5. Under Print settings, change the Scale to fit if needed. A scale of 100% will print your gridlines as is, while a smaller percentage like 75% will fit more cells on the page at the cost of reducing your gridline visibility.

6. Click Print to send your document to your printer.

Print Preview for Fine-Tuning

Before you send your document to the printer, use the Print Preview to ensure everything looks the way you want:

  1. With the selected range or entire sheet highlighted, click on the File tab.
  2. Click on Print Preview.
  3. Adjust scale, margins, and other settings as needed.
  4. Click Print when you're ready.

And there you have it! You've successfully printed your Excel sheet with gridlines. This step-by-step guide should help you maintain that clean, organized look on paper every time.

Happy printing! Now that you've mastered gridlines, why not explore other Excel printing tricks to enhance your data's presentation? The possibilities are endless, so keep exploring and widening your Excel expertise!