How to Print a Chart in Microsoft Excel With Lines

1. Open the Microsoft Excel document that you want to print with gridlines.
2. Click on the worksheet tab that you want to print, in the bottom left of the document.
3. Highlight all of the cells and gridlines that you want to print.
4. Click on the 'Page Layout' tab and find the 'Print Area' group. Click 'Set Print Area' to select the highlighted cells as the printable area of the document. This is an optional step. Note that if you do not set the print area, Excel will only print the data and its accompanying cells.
5. Locate the 'Sheet Options' group in the 'Page Layout' tab. Place a checkmark next to 'Print' in the 'Gridlines' section.
6. Preview the document by pressing 'Ctrl' and 'F2' simultaneously. This opens the 'Print Preview' window. Click 'Close Print Preview.' Make necessary changes and repeat this step until you are happy with your document.
7. Click the 'Office' button in the top left of the window and select 'Print.' Click 'OK' to print the document with lines.