How to Print a Blank Excel Chart Spreadsheet
When you print an Excel spreadsheet, it is normally to get a hard copy of the information inside the cells and not the cells themselves. Occasionally, however, you may simply need a piece of paper with the Excel gridlines on it so you can work things out by hand. Although you can see the gridlines on the screen, Excel will not include them when you print something unless you take a few steps to make them visible.
Launch "Excel." Click the "New" button at the top of the Excel program to open up a blank worksheet.
Select the "Page Layout" tab, located above the ribbon. Locate the "Sheet Options" area of the ribbon, and then find the "Gridlines" section. Place a check mark next to the "Print" option under the "Gridlines" section. When you do this, you will see a dotted line appear on the worksheet, showing you where the page breaks are.
Select cell "A1" and hold the mouse button down. Drag the mouse down and to the right, until you reach the intersection of the first vertical and horizontal page-break line. Position your pointer to the cell directly above the horizontal line and directly to the left of the vertical one, then release the button.
Locate the "Page Area" section of the ribbon. Click on "Print Area" and select "Set Print Area."
Click the "File" tab at the top of the Excel window. Choose "Print" from the list of options. Click the "Print" button near the top of the window. One sheet of just the Excel gridlines will now print.
Tips & Warnings
- If you have the "Draft Quality" option selected, you won't be able to print gridlines, no matter what else you do. Select the arrow next to the "Page Setup" area, and then select the "Sheet" tab. Remove the check mark next to "Draft Quality."