Select the small, blue-shadowed A in the WordArt Styles group. Notice that the Drawing Tools/Format menu is visible when WordArt or a graphic is selected. Type (for example) Certificate of Excellence in the text box. Next, select a WordArt style from Insert > Text. (If graphic design isn’t your thing, search “award certificates” online for examples and inspiration.)Ĭhoose some decorative borders, select Insert > Illustrations > Online Pictures. The rest is the fun part: choosing graphics and a font that fits the certificate’s theme. Set the Header and Footer margins to 0, then check both boxes under Center on Page: Horizontally and Vertically. From the same group, select the Margins tab and enter. Next, from the Page Layout tab’s Page Setup group, select Orientation > Landscape. From the Home tab’s Font group, click the option arrow (down) and select Outside Borders (in a very light gray color) from the drop list. Most people create certificates (and labels) in Microsoft Word, but Excel can do it, too. The labels in this spreadsheet are based on the “Address Label, 30 per sheet – 1 x 2 5/8” (a common size available everywhere).ĭecorate those address labels with a company logo or a colorful picture. The easiest way to design label sheets is to review the actual labels online at sites such as Avery, (which provides the size and placement of the labels on an 8.5×11-inch sheets). This one is a cinch for Excel and you can add lots of mini pictures to the labels to jazz up the aesthetics or use your company logo. Now, just print as many as you need (and don’t forget to save your work). From the Page Layout tab’s Page Setup group, click Print Area > Set Print Area. Highlight the range again (cells A1 through BD83). Set the Header and Footer margins to 0, then check both boxes under Center on Page: Horizontally and Vertically.īefore you close this dialog box, select the Sheet tab, check the box for Gridlines, then click OK. Select the Margins tab in the Page Setup dialog, and enter.
![ho scale graph paper maker ho scale graph paper maker](https://venturebeat.com/wp-content/uploads/2018/06/6335692769_0184646f4f_b1.jpg)
From the Page Layout tab’s Page Setup group, select Margins > Custom. Next, change the margins to a half-inch on all sides.
![ho scale graph paper maker ho scale graph paper maker](https://i.pinimg.com/736x/fa/b8/f7/fab8f711e515d3512c9ca4b8536ff72a.jpg)
With the same range still highlighted, select Format > Row Height. Enter 9 in the dialog box and click OK. From the Home tab’s Cells group, select Format > Column Width. Enter 1 in the dialog box and click OK. For a standard 8.5×11-inch piece of paper, highlight cells A1 through BD83. Excel includes many calendar templates for additional options.Īll you want is a few sheets of grid/graph paper in a hurry.