Creating Banners in Excel

Creating Banners in Excel

Remember the days when you could create banners in Printshop and we used the old continuous feed printer paper? This is a way to create those banners using Excel. They will of course print out on separate sheets but you can laminate them to create a continuous banner to hang on your room.

I. Setting up the pages:
A. Click on File/Page Setup
B. Click on margins tab
1. Change all margins to .25 (smallest value)
2. Change header and footer margins to 0
C. You might also need to click on the Page tab and change your layout from portrait to landscape.
D. Click OK
E. Click on View menu and select page break
1. You will notice that the cells turn dark gray. Don’t worry, we will fix that.
F. Click on View menu and select Normal
G. Still on the View menu, change your zoom to 25%
1. The dotted lines show page breaks. Each dotted rectangle is one page.
H. Add WordArt, graphics, borders, text boxes, and autoshapes. Make them large.
I. Be sure not to place an object beyond the margins
J. Go to File and select Print Preview
K. Look in the lower left corner of the screen and you will see the length of your banner displayed. Make adjustments in size if needed.
L. Trim about ½ inch from one side of each page and tape your pages together on the back

No puppies were harmed in the creation of this tutorial and it has been tested on Office 2003 (PC and Mac)