Printing an Excel spreadsheet in a readable format usually requires a lot of formatting adjustments. While the specific changes that you need to make will vary based on your current spreadsheet, one very common adjustment is to print the gridlines. This visually separates the data in your individual cells, making it easier for your audience to absorb the information.
Our tutorial below will show you a short method that will cause the gridlines to print on your spreadsheet in Excel 2013. We even offer an alternative solution in the event that these steps don’t cause the gridlines to appear.
How to Include the Cell Lines When You Print a Spreadsheet in Excel 2013
These steps were performed in the 2013 version of Excel 2013, but will also work for users of Excel 2010.
Step 1: Open the spreadsheet for which you would like to print your gridlines.
Step 2: Click the Page Layout tab at the top of the window.
Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section of the ribbon.
Now when you open Print Preview, you should see lines around all of the cells in your spreadsheet.
If you don’t see gridlines, then you may have a fill color applied to your cells. If that is the case, then you will need to use borders instead. You can apply border by selecting all of the cells in the spreadsheet, clicking the Home tab at the top of the window, clicking the arrow to the right of the Borders button, then clicking the All Borders option.