How to Print Excel Sheet with Gridlines

Printing an Excel sheet with gridlines visible might seem like a straightforward task, butExcel can sometimes hide these lines by default. Here, we'll guide you through the process of printing your Excel sheet with visible gridlines in two popular scenarios: printing the entire worksheet and printing a selected range.

If you're printing your Excel sheet for offline reference or presentation, visible gridlines can help maintain context and clarity. So, let's dive into the step-by-step process to make this happen.

Printing Entire Worksheet with Gridlines

This method is useful when you want to print the entire worksheet, including all its contents and visible gridlines.

For broader visibility, let's discuss the two versions of Excel used widely - Excel for Office 365 (Subscription) and Excel 2019 (Standalone).

In Excel for Office 365 or Excel 2019

Both these versions share the same process for printing with visible gridlines.

First, open your Excel file and navigate to the worksheet you want to print. Then, follow these steps:

1. Enable gridlines in your worksheet. Go to the Home tab, click on Format under Cells, and select Format as Table or press Ctrl + T. In the dialog box, check My table has headers if your data includes headers, select the table range, and click OK.
2. Access the print settings. Press Ctrl + P (or Command + P onMac) to open the print settings dialog box. Alternatively, go to the File tab, select Print, and click on the print settings icon (gear icon).
3. Configure the print options. Under Settings, ensure that the Print Gridlines box is checked. Leave other settings as per your requirements, such as paper size and orientation.
4. Print your worksheet. Click on the Print button to begin printing your worksheet with visible gridlines. You can always preview the print layout before finalizing.

In Older Versions of Excel (2007/2010/2013)

Printing settings in older Excel versions are slightly different than the preceding versions. Follow these steps:

1. Launch the Print dialog box by pressing Ctrl + P (or Command + P on Mac).

2. Go to Page Setup and click on Print what. Here, ensure that the Entire worksheet or Selection (based on your requirement) is selected.

3. Move to the Page Setup tab and check the Print gridlines box under Sheet.

4. Configure other print settings as required (e.g., paper size, margins) and click Print.

Printing a Specific Range with Gridlines

Sometimes, you might want to print only a specific range of cells with gridlines. Here's how to do it using Excel for Office 365 or Excel 2019:

Step-by-Step Process

1. Open the Excel worksheet containing the data range you want to print.

2. Select the range of cells you want to print. Click and drag your mouse over the desired cells, or use the mouse to create a marquee selection.

3. Enable gridlines for the selected range by right-clicking anywhere within the selection and choosing Format as Table. Alternatively, press Ctrl + T. In the dialog box, check My table has headers (if applicable), select the table range, and click OK.

4. Access the Print dialog box by pressing Ctrl + P (or Command + P on Mac).

5. Configure the print settings, ensuring the Print Gridlines box is checked and other settings are correct.

6. Click Print to start the printing process, previewing the layout before finalizing.

Now that you know how to print your Excel worksheets with visible gridlines, why not try it out and share your newfound knowledge with others? Happy printing!