Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Please follow the same steps introduced in above method to set sheet margins, headers, and gridlines. (3) Configure for quad paper: choose Inches as unit type, specify both row height and column width as 0.25, and click the Ok button. (2) Configure for engineering paper: choose Inches as unit type, specify both row height and column width as 0.2, and click the Ok button. (1) Configure for millimeter paper: choose Centimetres as unit type, and specify both row height and column width as 0.1, and click the Ok button. In the Adjust Cell Size dialog, please configure the cell size as follows: Click Kutools > Format > Adjust Cell Size to open the Adjust Cell Size dialog.ģ.
Full feature free trialģ0-day, no credit card required! Free Trial Now!Ģ. With Kutools for Excel’s Adjust Cell Size feature, you can easily turn a sheet into common millimeter paper, engineering paper, and quad paper in Excel.ģ00 handy tools for Excel. Turn a sheet into millimeter/engineering/quad paper with Adjust Cell Size featureĪs you know, there are many styles of graph papers, and some users might not remember the size of each graph paper. For printing the graph paper, please select one page in the sheet, and click File > Print > Print Selection to print it directly. Now the active sheet is turned into a graph paper.
Still in the Page Setup dialog, under Sheet tab, check the Gridlines option in the Print section, and click the OK button. (3) Check both Horizontally and Vertically options in the Center on page section.Ĩ. (2) Type 0 in the Header and Footer boxes (1) Type 0.5 in the Top / Right / Bottom / Left boxes separately In the Page Setup dialog, under the Margins tab, please do as follows: Click Page Layout > Margins > Custom Margins to open the Page Setup dialog.ħ. In the Column Width dialog, type 1 in the Column Width box, and click the OK button. Keep all cells selected, and click Home > Format > Column Width to open the Column Width dialog.ĥ. In the Row Height dialog, type 9 in the Row height box, and click the OK button. Click Home > Format > Row Height to open the Row Height dialog.ģ. Click the Arrow at the top-left corner of working area to select all cells in the active sheet.Ģ. To turn a sheet into graph paper in Excel, please do as follows:ġ.