How to Create Flyers in Excel

Excel is one of the applications that can be used to create flyers tailored to a specific purpose. Since flyers consist of a single-sided or two-sided page of information, the table in a spreadsheet offers an easy formatting solution for novices to layout text and pictures. Advanced functions in programs such as Excel for text orientation rival those in word processing programs. Data from another worksheet can automatically update an embedded chart (such as the local real estate status).

Couple using laptop
credit: Creatas Images/Creatas/Getty Images

Prepare Layout

Step

Open a blank Excel spreadsheet (worksheet).

Step

Select "Page Setup" under "File" and click the "Margins" tab to adjust the top, bottom, left and right margins of the page and to center the spreadsheet horizontally and vertically. Click the "OK" button.

Step

Confirm that a thin, dotted line appears to the right of the row of numbers, specifying the limit of the spreadsheet that fits on the page.

Step

Activate the Formatting and Drawing toolbars for easy access to common functions such as fonts, alignment, colors and shapes by selecting "Toolbars" under "View" in the top menu bar and choosing "Formatting" and then "Drawing."

Step

Adjust the widths of columns by selecting the column header (e.g., "A," "B" or "C") and clicking the left or right margin to widen the column width. Make sure to include a thinner separator column that will be blank between the columns of text.

Step

Choose "Select All" under "Edit."

Step

Select "Cells" under "Format" and click the "Font" tab.

Step

Select the desired font and font size for the content (and color, if desired).

Step

Click the "Alignment" tab and select "Top" from the drop down menu under "Vertical" in the "Text Alignment" section.

Step

Click the "OK" button.

Step

Identify the row for the headline (usually the first row) and highlight the cells that span the width of the page.

Step

Select "Cells" under "Format" and click the "Alignment" tab.

Step

Select "Merge cells" and click the "OK" button.

Insert Content

Step

Insert a graphic file by selecting "Picture" under "Insert" and choosing "Picture from File."

Step

Select the desired picture and click the "Insert" button.

Step

Reposition and resize the picture.

Step

Type in content to fit in each cell. Press the "Enter" key to move to the cell below to continue typing information.

Step

Insert a chart from another spreadsheet by opening the desired file, copying the chart and then pasting it into the flyer. The chart data is linked to the source spreadsheet.