If you are working with Excel 2007, you can use the Print Gridlines feature to create gridlines in your workbook file. This feature is available in the ribbon under the Format tab. To use the Print Gridlines feature, first open your workbook and click on the File tab. Then click on the Options button and select the Print Gridlines check box. Next, enter a value for the Horizontal Margin field and click on OK. Finally, close your workbook and reopen it to see the results of your choice.
When you are ready to print out the Excel document click Page Layout tab on the Ribbon, then click on Page Setup
In the Page Setup dialog box click on the Sheet tab. Place a checkmark next to Gridlines and click OK. When you print your document you will now have the gridlines appear with your data!
