How to Make a Grid in Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: Huntstock/DisabilityImages/Getty Images

Working in Microsoft Excel 2013 without gridlines can make sense for some projects. However, if someone sent you a file and you need gridlines to make sense of everything, you can re-enable gridlines through the Ribbon toolbar. Alternatively, if the file you look at on your computer has gridlines and the printed file doesn't, you'll need to re-enable the ability to print the file with gridlines through the Page Layout menu on the Ribbon toolbar.

Advertisement

Show Gridlines

Step 1

Click to select the workbook you want to display gridlines within in the lower left corner of the screen. Alternatively, if you want to activate gridlines in multiple workbooks, hold down the "Shift" button and select the workbooks in which you want to display gridlines.

Advertisement

Video of the Day

Step 2

Select the "View" tab on the Ribbon toolbar.

Step 3

Click to place a check mark next to Gridlines in the radio box in the Show section. Gridlines will be activated in the selected workbooks.

Advertisement

Step 1

Select the workbooks you want to make sure get printed with the gridlines displayed.

Advertisement

Step 2

Select "Page Layout" on the Ribbon toolbar.

Advertisement

Step 3

Click to place a check mark next to "Print" in the radio box in the Sheet Options section. Gridlines will now appear on documents printed from these workbooks.

Advertisement

Advertisement

Report an Issue

screenshot of the current page

Screenshot loading...