How To Print Gridlines In Excel

To print gridlines in Excel, go to the Page Layout tab, click on the Print Gridlines checkbox in the Sheet Options group, and then print the worksheet.

Excel is a powerful tool that allows users to organize and manipulate data with ease. Whether you are working on financial analysis, project management, or simply keeping track of your personal budget, Excel provides a multitude of features to enhance your experience. One often overlooked feature is the ability to print gridlines, which can greatly improve the readability and clarity of your data when printed. In this blog post, we will guide you through the steps to print gridlines in Excel, ensuring your data is presented in a neat and organized manner. So, let’s dive in and uncover this handy Excel feature!

How To Print Gridlines In Excel: Step-by-Step


Step 1: Open the Excel File

To begin, locate and open the Excel file that you wish to print with visible gridlines.

Next Step

Step 2: Select the Page Layout Option

At the top of your Excel worksheet, you will find a tab labeled ‘Page Layout’. Open it and access various options to customize the layout of your worksheet.

Next Step

Step 3: Tick the Print Gridlines Box

Under the ‘Page Layout’ tab, locate the ‘Print’ box with the ‘Gridlines’ option. Enable this to make worksheet gridlines visible when you print it.

Next Step

Step 4: Set the Print Area

To selectively print a section of the worksheet, navigate to ‘Print Area’ in the ‘Page Setup’ group, choose ‘Set Print Area’, and specify the desired cells. Skip this if printing the entire worksheet.

Next Step

Step 5: Go to Print Preview

To preview your printed document, go to the ‘File’ tab and click on ‘Print’. This will give you a sneak peek of how your document will appear when printed, helping you make any necessary adjustments before finalizing.


In conclusion, learning how to print gridlines in Excel is a valuable skill for anyone who works extensively with spreadsheets. By displaying the gridlines on the printed copy, you can enhance the readability and organization of your data, making it easier to analyze and interpret. Whether you are preparing reports, conducting data analysis, or simply sharing information with others, printing gridlines ensures that your audience can navigate through the document with ease. With the step-by-step guide provided in this blog post, you can effortlessly customize your Excel settings and print gridlines whenever necessary. Take advantage of this feature to present your data in a polished and professional manner.

Table of Contents