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:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |