How to Create Flyers in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: Creatas Images/Creatas/Getty Images

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).

Advertisement

Prepare Layout

Video of the Day

Step 1

Open a blank Excel spreadsheet (worksheet).

Video of the Day

Step 2

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.

Advertisement

Step 3

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 4

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."

Advertisement

Step 5

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 6

Choose "Select All" under "Edit."

Advertisement

Step 7

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

Advertisement

Step 8

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

Step 9

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

Advertisement

Step 10

Click the "OK" button.

Step 11

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

Step 12

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

Advertisement

Step 13

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

Insert Content

Step 1

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

Advertisement

Step 2

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

Step 3

Reposition and resize the picture.

Step 4

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

Advertisement

Step 5

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.

Advertisement

Advertisement

references