How to Make Graphing Paper in Excel

1. Open a new Microsoft Excel 2010 spreadsheet. Click on the small square above the '1' and to the left of the 'A' in the spreadsheet's top-left corner. This will select the entire spreadsheet.
2. Move your mouse between the 'A' and 'B' at the top of the spreadsheet. Once the pointer changes to appear as a line with two opposite arrows coming off of it, click and hold the mouse button. Drag the mouse to the left to shorten the columns until you get the horizontal spacing that you desire for your graph paper. Make note of the number of pixels that appear in the small popup box above your mouse pointer.
3. Click on the line between the '1' and '2,' in the same manner as you did between the 'A' and 'B' columns. Drag the mouse up or down until the pixel number reads the same as it did when you adjusted your columns. When the number is the same, release the mouse button and your spreadsheet lines will new create perfect squares.
4. Click 'File' at the top of the Excel window and then choose 'Print' from the list on the left side of the screen. Click the 'Normal Margins' button and choose 'Custom Margins' from the menu that appears. Click the down arrow next to each margin to reduce it to zero, then click 'OK.' Click the 'Home' tab to return to your spreadsheet.
5. Click and hold the mouse button on cell 'A1.' Drag your mouse down and to the right until you get to the first cell that is in a corner created by the dotted page-break lines. Release the mouse button. Click the drop-down arrow next to 'Borders' in the Font area of the ribbon, then choose 'All borders' from the available options. Your spreadsheet will not have darkened gridlines that will show up when you print the page.
6. Click the 'File' tab and select 'Print' from the list of options. Click the 'Last Custom Margins Setting' button and choose 'Custom Margins' from the menu. Place a check mark next to 'Horizontally' and 'Vertically,' then click 'OK.'
7. Click the 'Print' button near the top of the window to print a page of your graphing paper.