Quick Guide: Print Excel Worksheets with Gridlines

---

Introduction

Printing Excel worksheets with gridlines can be essential for maintaining clarity and readability, especially when sharing data with others. However, many users may find it challenging to ensure that gridlines are included in their printed documents. This guide will provide detailed solutions to help you print Excel worksheets with gridlines, along with the success rate of each method.

---

Why You Might Need to Print with Gridlines

1. Readability: Gridlines help distinguish between cells, making the data easier to read.
2. Professional Appearance: Including gridlines can make your printed documents look more polished and organized.
3. Data Analysis: Gridlines can assist in analyzing and comparing data in printed form.
4. Consistency: Ensuring that gridlines are printed can maintain consistency with on-screen views.

---

Detailed Solutions

Method 1: Enable Gridlines in Print Settings

Success Rate: 95%

Excel provides an option to print gridlines directly from the print settings.

1. Open Your Workbook: Launch Excel and open the workbook you want to print.
2. Access Print Settings:

• Go to File > Print.

1. Enable Gridlines:

• In the Settings section, check the box for Print > Gridlines.

1. Print the Worksheet: Click Print to print the worksheet with gridlines.

---

Method 2: Use Page Layout View

Success Rate: 90%

Page Layout view allows you to see how your worksheet will look when printed, including gridlines.

1. Open Your Workbook: Launch Excel and open the workbook you want to print.
2. Switch to Page Layout View:

• Go to the View tab and click Page Layout.

1. Enable Gridlines:

• In the Page Layout view, gridlines are automatically displayed.

1. Print the Worksheet: Go to File > Print and click Print to print the worksheet with gridlines.

---

Method 3: Use the Print Preview Option

Success Rate: 85%

Print Preview allows you to review your document before printing, ensuring that gridlines are included.

1. Open Your Workbook: Launch Excel and open the workbook you want to print.
2. Access Print Preview:

• Go to File > Print.

1. Enable Gridlines:

• In the Print window, check the box for Print > Gridlines.

1. Review and Print: Use the Print Preview option to review your document. If everything looks correct, click Print.

---

Method 4: Adjust Page Setup Options

Success Rate: 90%

Page Setup options allow you to configure various print settings, including gridlines.

1. Open Your Workbook: Launch Excel and open the workbook you want to print.
2. Access Page Setup:

• Go to File > Page Setup.

1. Enable Gridlines:

• In the Page Setup dialog box, go to the Sheet tab.
• Check the box for Print > Gridlines.

1. Print the Worksheet: Click OK and then go to File > Print to print the worksheet with gridlines.

---

Method 5: Use VBA to Print with Gridlines

Success Rate: 95%

A VBA macro can automate the process of printing worksheets with gridlines.

1. Open the VBA Editor:

• Press Alt + F11 to open the VBA editor.

1. Insert a New Module:

• Right-click on any existing module, select Insert > Module.

1. Enter the VBA Code:

   Sub PrintWithGridlines()
       With ActiveSheet.PageSetup
           .PrintGridlines = True
           .Print
       End With
   End Sub

4. Run the Macro:

• Close the VBA editor.
• Press Alt + F8, select PrintWithGridlines, and click Run.

---

Summary

Printing Excel worksheets with gridlines can be accomplished using several methods, each with its own success rate. Here’s a quick summary:

1. Enable Gridlines in Print Settings: Use the print settings to enable gridlines.
2. Use Page Layout View: Switch to Page Layout view to see and print gridlines.
3. Use the Print Preview Option: Review your document in Print Preview and enable gridlines.
4. Adjust Page Setup Options: Configure Page Setup to include gridlines in your printout.
5. Use VBA to Print with Gridlines: Automate the process with a custom VBA macro.

By applying these methods, you can ensure that your Excel worksheets are printed with gridlines, making your documents clearer and more professional.

---

Tip: Always review your document in Print Preview before printing to ensure everything looks as expected.

Note: For repetitive tasks, consider using VBA macros to save time and effort.