How To Print a Blank Spreadsheet With Gridlines – Usually print an Excel spreadsheet, it is to get a hard copy of the information inside the cells, but not the cells themselves. Occasionally, sin embargo, you may simply need a piece of paper with Excel Grid lines for things to solve things by hand. Although you can see the grid sheets on the screen, Excel is not limited to the impression that less takes some steps to make visible.
1 Open “Excel”. Click the “New” button at the top of the program to open a blank worksheet.
2 Select the “Page Layout” option, which is located above the ribbon. Find the “Sheet Options” section and then find the “Grid” section. Place a check mark next to the “Print” option in the “Split lines” section. When you do this, you’ll see a dotted line that appears on the worksheet that shows where the page breaks are.
3 Select cell “A1” and hold down the mouse button. Drag the mouse down and to the right until you reach the intersection of the vertical page break with the horizontal one. Place the pointer in the cell directly above the horizontal line and directly to the left of the vertical, then release the button.
4 Locate the “Page Area”. Click “Print Area” and select “Set Print Area.”
5 Click the “File” tab at the top of the Excel window. Select the “Print” option from the list of options. Click the “Print” button at the top of the window. An Excel sheet with only the grid lines will be printed.