Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

Bet you didn't know Excel could do: graph paper, address labels, award certificates

JD Sartain | Aug. 3, 2015
The list of 'anythings' Excel can do keeps growing, as new versions with more templates and better features are released. Many prefer the simplicity of Excel over Word because it offers a huge, very adaptable grid with drag-and-drop graphics that are easy to manipulate.

Open a blank spreadsheet in Excel. Hold down the Ctrl key and click cells A1, C1, and E1. From the Home tab's Cells group, select Format > Column Width, type 29 in the column width box, and click OK. Next, hold down the Ctrl key and select cells B1 and D1. From the Home tab's Cells group, select Format > Column Width, type 5 in the column width box, and click OK.  Now this spreadsheet matches the size of the labels and the space between them.

Press Ctrl+Home. Enter the company (or person's name) in cell A2. Enter the address in A3, and the city, state, zip in cell A4. Copy A2 thru A4 to C2 and E2. Place your cursor on cell A2 and highlight the range A2 through E4. Press Ctrl+C to copy (or select the Copy button on the Home tab> Clipboard group), then move to A7 and press Ctrl+V to paste. Continue to copy this range to A12, A17, A22, A27, A32, A37, A42, and A47. You now have a complete sheet of labels.

Add some flair with your company logo or some small images of your choice. Move your cursor to A53. From the Insert tab, select Illustrations > Pictures Online. Enter a topic, select an image, then click Insert. Size the image to fit on the right side of each label, then choose a border from Picture Format > Picture Border. Copy this image to the other labels or insert a different image for each label. Save your work.

Note: You can use this same template to create name/ID tags, place cards, folder labels, or even food labels for canning jars.


Most people create certificates (and labels) in Microsoft Word, but Excel can do it, too.

Open a blank Excel spreadsheet. Highlight A1 through N43. 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. Next, from the Page Layout tab's Page Setup group, select Orientation > Landscape. From the same group, select the Margins tab and enter .25 for Top, Bottom, Left, and Right. Set the Header and Footer margins to 0, then check both boxes under Center on Page: Horizontally and Vertically. Click OK.

The rest is the fun part: choosing graphics and a font that fits the certificate's theme. (If graphic design isn't your thing, search "award certificates" online for examples and inspiration.)

Choose some decorative borders, select Insert > Illustrations > Online Pictures. Next, select a WordArt style from Insert > Text. Type (for example) Certificate of Excellence in the text box. Notice that the Drawing Tools/Format menu is visible when WordArt or a graphic is selected. Select the small, blue-shadowed A in the WordArt Styles group. Click Transform from the List menu, then select a Path or Warp to bend your text.


Previous Page  1  2  3  Next Page 

Sign up for Computerworld eNewsletters.