List Your Business in Our Directory Now! 

How to Print Grid Lines in Excel

Written by:

Last updated:

How to Print Grid Lines in Excel

Printing grid lines in Microsoft Excel is an essential feature that helps users maintain the structure and organization of their data when printed on paper. While it may seem like a straightforward process, some users may have trouble finding the correct settings to enable this feature. Fortunately, Excel provides several options that allow users to customize the grid lines when printing their worksheets. In this blog post, we will cover how to print grid lines in Excel, including step-by-step instructions and some useful tips to help you get the most out of this feature.

Understanding Grid Lines in Excel

Before diving into printing grid lines, it’s essential to understand what they are. Grid lines in Excel refer to the faint lines that appear around cells. They help to differentiate between cells, rows, and columns, making it easier to read and analyze data on a digital or print medium. By default, Excel turns off grid lines when printing, but users can easily turn them on and customize their appearance.



Turning on Grid Lines

The first step in printing grid lines in Excel is to turn them on. To do this, follow the steps below:

  1. Select the worksheet that you want to print.
  2. Click on the Page Layout tab in the Excel ribbon.
  3. Under the Sheet Options group, check the Print box for Gridlines.

Alternatively, you can use the keyboard shortcut Ctrl + P to open the Print dialog box. In the Settings section, make sure the Gridlines option is checked, and click on the Print button.

Customizing Grid Line Appearance

Excel allows users to customize the appearance of grid lines when printing to fit their specific needs and preferences. Here’s how to do it:

  1. Select the worksheet that you want to print.
  2. Click on the Page Layout tab in the Excel ribbon.
  3. Under the Sheet Options group, click on the arrow next to Gridlines, and select the desired option:
    • Print: prints grid lines in their default format.
    • Black and White: prints grid lines in black and white format.
    • Display or Hide: allows you to choose which grid lines to print or hide. To do this, click on the View tab, select the options from the Show group, and return to the Page Layout tab to print your worksheet.

Wrap Up

Printing grid lines in Excel is a handy feature that helps preserve the structure and organization of your data when printed on paper. By following the simple steps outlined in this article, you can easily turn on grid lines and customize their appearance when printing. Whether you’re an Excel beginner or an advanced user, this feature is sure to make your data look more professional and easier to read on paper.

Printing Grid Lines in Large Worksheets

If you have a large worksheet with numerous rows and columns, printing grid lines can get challenging unless you make some configurations. It may make your worksheet look overcrowded and cause it to occupy multiple pages when printed. Here are some tips to help you print grid lines in large Excel spreadsheets:

  • Adjust the scaling options to fit more of the worksheet on one page and reduce the number of pages printed.
  • Since every printer has different settings, it may require some experimentation to find the ideal scaling option that fits the content and prints the grid lines.
  • If your worksheet goes beyond one page, consider printing it in landscape orientation instead of portrait mode to fit more data on one page.

Printing Grid Lines with Color

If you prefer printing the grid lines with colors, you can either use the default color or customize it to match your preference. Here’s how:

  1. Select the worksheet that you want to print.
  2. Click on File > Print.
  3. In the Settings section, click on the dropdown menu next to the Gridlines option.
  4. Select the desired color from the menu or customize it by choosing More Colors.
  5. Click the Print button to confirm the changes.

Printing grid lines in Excel can be an essential feature that helps you keep your worksheet organized when printing. It is easy to enable and customize the grid lines when printing your Excel worksheet with the steps outlined in this article. Whether you are printing a large worksheet or need to add some color to your grid lines, the information presented will help you create professional-looking documents that are easier to read.

FAQs on Printing Grid Lines in Excel

Here are some frequently asked questions (FAQs) about printing grid lines in Excel and their answers:

Can I print grid lines in Excel without printing the cell borders?

Yes, you can print grid lines without printing the cell borders in Excel. Simply go to File > Print, select the worksheet you want to print, and uncheck the “Borders” checkbox under “Settings” in the print dialog box. Then, click Print to print the worksheet with grid lines only.

How do I remove grid lines when printing in Excel?

To remove grid lines when printing in Excel, select the worksheet you want to print, click on Page Layout > Sheet Options and uncheck the “Print” option under Gridlines. Alternatively, you can use the “Display or hide” feature under Gridlines to choose which grid lines to print or hide.

Why don’t my grid lines show up in Excel when I print?

If grid lines do not appear when you print your Excel worksheet, ensure that the “Gridlines” option is selected in the print dialog box. Also, check that the color of the gridlines contrasts the color of the cells to ensure they show up when printed. Finally, make sure that a white background option is selected in the printer settings.

Can I customize the color of the grid lines when printing in Excel?

Yes, you can customize the color of grid lines under Print options. To do this, select the worksheet you want to print, click on File > Print, click on the dropdown menu next to the Gridlines option under Settings, then select “more colors” to choose a color that suits you.

Can I print grid lines on only specific pages in Excel?

Yes, you can choose to print grid lines on specific pages of an Excel worksheet instead of the entire worksheet. To do this, select the pages or range of cells you want to print, click on Page Layout > Print Area > Set Print Area. After that go to File > Print and select either the “Print Active Sheets” or “Print Selection” option under Settings to print only the selected range with grid lines.

Bill Whitman from Learn Excel

I'm Bill Whitman, the founder of LearnExcel.io, where I combine my passion for education with my deep expertise in technology. With a background in technology writing, I excel at breaking down complex topics into understandable and engaging content. I'm dedicated to helping others master Microsoft Excel and constantly exploring new ways to make learning accessible to everyone.

Categories Excel Printing

Featured Companies

  • Learn PowerPoint

    Explore the world of Microsoft PowerPoint with LearnPowerpoint.io, where we provide tailored tutorials and valuable tips to transform your presentation skills and clarify PowerPoint for enthusiasts and professionals alike.

    Learn PowerPoint
  • Learn Word

    Your ultimate guide to mastering Microsoft Word! Dive into our extensive collection of tutorials and tips designed to make Word simple and effective for users of all skill levels.

    Learn Word
  • Resultris Marketing

    Boost your brand's online presence with Resultris Content Marketing Subscriptions. Enjoy high-quality, on-demand content marketing services to grow your business.

    Resultris Marketing

Other Categories

Expand Your Market with a Listing in Our Excel-Focused Directory!