WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Print Excel Gridlines

Print Excel Gridlines

Print Gridlines in Excel Worksheet (Step by Step)

Follow the Simple and Easy Steps to Print Excel Sheet with Gridlines –

  • Step 1: First, we need to select the view section from the grid lines tab in page layout.
  • Step 2: Then, to print it, we need to select the print box available in the grid lines tab.
  • Step 3: And then finally, we can go to the print section and click on the print preview to see the grid lines.

2 Different Methods to Print Excel Sheet with Gridlines

  1. Print gridlines using Page Layout.
  2. Print gridlines using Page Setup

Now let us discuss each of the methods in detail –

#1 – Using Page Layout Tab

Below is the data I want to print, and it has no borders.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Print Gridlines Using Page Layout 1

  • Step 1: Go to PAGE LAYOUT > Sheet Options > Grid Line > and check the box > View & Print.

Print Gridlines Using Page Layout 2

  • Step 2: We can only VIEW the gridlines here. If you want to print, we need to tick the checkbox of PRINT. This would print gridlines for you. Look at the below print preview image.

Print Gridlines Using Page Layout 3

#2 – Using the Page Set Up Tab

Below is the data I want to print, and it has no borders. You can print an excel sheet with gridlines under page set up as well.

Print Gridlines using Page Setup step 1

  • Step 1: Go to PAGE LAYOUT, under this click on the little expand icon.

Print Gridlines using Page Setup step 2

  • Step 2: Now go to the SHEET tab under below dialogue box.

Print Gridlines using Page Setup step 3

  • Step 3: Under the SHEET tab, we have a PRINT section; select the Gridlines check box.

Print Gridlines using Page Setup step 4

  • Step 4: After you have selected the option Gridlines, at the end of this dialogue box, click on Print Preview in excel.

Print Gridlines using Page Setup step 5

  • Step 5: It will show the preview of your print with Gridlines.

Print Gridlines using Page Setup step 6

How to Print Gridlines with Different Color?

By default, gridline color is light gray in excel. While printing, the gridline with default color looks very shuttle. We can change the color of the grid line according to our preference and makes the line more beautiful. Follow the below steps to change the color of the Grid Line.

  • Step 1: Go to File, then select OPTIONS.

Color step 1

  • Step 2: Under Options, go to Advanced.

Different Color step 2

  • Step 3: After selecting Advanced, scroll down, select Display options for this worksheet.

Different Color step 3

  • Step 4: In this section, at the bottom, we have an option called Gridline color.

Different Color step 4

  • Step 5: Select the color as per your requirement.

Different Color step 5

  • Step 6: Now, we have a pink grid line.

Different Color step 6

Things to Remember

  • ALT + W + V +G is the short cut key to show and hide GridLines in Excel.
  • Whatever the changes you make for the gridline are applicable only for the current worksheet. For each sheet, you have to do it separately.
  • Removing and applying gridlines is applicable for the whole worksheet, not for the portion of the worksheet.
  • In one shot, we can remove the gridline by holding the control key and select all the worksheets and click on remove gridlines.
  • Excel cannot print the gridlines without you insist.

Recommended Articles

This has been a guide to Print Gridlines in Excel. Here we discuss how to Print Gridlines using the top three ways (Page Layout, Page Setup, and with a different color) along with examples. You may also look at these useful functions in excel –

  • Print in VBA
  • Gridlines in Excel
  • Print Comments in Excel
  • Split Panes in Excel
  • Excel Group Sum
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More