How to print Excel with boxes

By default, when you print a worksheet in Microsoft Excel, the program removes the grid lines separating each cell. To preserve the grid lines in your printout, you must modify the display settings for each applicable worksheet. Microsoft Excel, however, only shows borders around cells containing actual data. If you want the program to print grid lines for empty cells as well, make sure to include those cells in the print area.

Table of Contents Show

How do I print columns and rows in Excel?
Why does Excel not print the gridlines?
How do I make boxes in Excel?
How do you set the print area to include the selected cells?

Select the worksheet or worksheets you want to print, and then click the "Page Layout" tab.
Check "Print" under Gridlines in the Sheet Options group, and then press "Ctrl-P" to go to the Print window.
Choose your printer from the associated drop-down menu, and then click the "Print" button to send your selected worksheet or worksheets to the print queue.

Excel does not automatically print the gridlines with the data when printing a worksheet or workbook. Gridlines make reading the data easier by separating the columns and rows from one another. Below is a side-by-side comparison of what the data will print like with and without gridlines in excel.

By printing the gridlines, the data is separated, and it is easier to read across the rows.

How to Show Gridlines in Excel When Printing

To turn on the Print Gridlines:

Go to the Page LayoutTab in the Ribbon
Find the Sheet Options Box
Under Gridlines, check the box to Print
Click the FileTab in the Ribbon
Click Print

Please note the Print Gridlines feature is only applicable to the worksheet you have opened. If you want to print the entire workbook with gridlines, you will have to repeat the steps in each worksheet by checking the Print box under Gridlines.

You can also select the right-hand corner of the Sheet Options box to display the Page Setup dialog box.

Choose the Sheet Tab from the Ribbon
In the Print options, click the box next to Gridlinesto turn on the Print Gridlines feature
Click OKto continue working on the worksheet or
Click Print

Again, this will have to be repeated for each worksheet you would like to print.

The Fastest Way To Have Gridlines Printed

When working with several worksheets that will be printed out, you need to click on File from the Ribbon. Select Print to bring up the Print Preview screen. The Settings are listed on the left side. To print all the worksheets, select the first drop-down menu and select Print Entire Workbook.

Underneath the Settings at the very bottom will be a link to open the Page Setup dialog box. Toggle through the worksheets by clicking the arrows. Once the worksheet you wish to change is visible, open the Page Setup and follow the steps above to turn on the Print Gridlines feature. Once you have turned Print Gridlines on for each worksheet, click Print.

Excel Only Prints the Gridlines

That is around data, so the empty cells within the worksheet aren’t going to have gridlines displayed. For instance, if you wanted to add a blank cell to the bottom of the column for additional figures to be hand-entered, you will have to insert Borders around the cells.

Another option is to include the empty cells within the print area. Within the worksheet, select all Columns and Rows that you want to print. Click on the File Tab and select Print. Within the first drop-down menu of the Settings, click Print Selection.

Turn on the Print Gridlines feature by opening the Page Setup and completing the steps. Now, all selected cells will have gridlines around them, even the cells without data.

How To Show Gridlines In Excel When Printing If Gridlines Aren’t Showing Up

Even though the box has been checked, Draft Quality has not been turned on. First, open the Page Setup dialog box. Just under the Print Gridlines in the Print options section, you will find Draft Quality. Make sure the box is unchecked. Draft Quality doesn’t include graphs, or graphics, or gridlines in excel. It is simply the raw data.

How do I print columns and rows in Excel?

On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box. , and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Why does Excel not print the gridlines?

Printing the Gridlines in Excel By default, gridlines in Excel are not printed. If you want to print the gridlines as well, make the following change: Go to Page Layout tab. In the Sheet Options group, within Gridlines, check the Print checkbox.

How do I make boxes in Excel?

Add a list box or combo box to a worksheet in Excel.

Create a list of items that you want to displayed in your list box like in this picture..

Click Developer > Insert. ... .

Under Form Controls, click List box (Form Control)..

Click the cell where you want to create the list box..

How do you set the print area to include the selected cells?

On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. Each print area prints on its own page. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.