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).
Open a blank Excel spreadsheet (worksheet).
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.
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.
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."
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.
Choose "Select All" under "Edit."
Select "Cells" under "Format" and click the "Font" tab.
Select the desired font and font size for the content (and color, if desired).
Click the "Alignment" tab and select "Top" from the drop down menu under "Vertical" in the "Text Alignment" section.
Click the "OK" button.
Identify the row for the headline (usually the first row) and highlight the cells that span the width of the page.
Select "Cells" under "Format" and click the "Alignment" tab.
Select "Merge cells" and click the "OK" button.
Insert a graphic file by selecting "Picture" under "Insert" and choosing "Picture from File."
Select the desired picture and click the "Insert" button.
Reposition and resize the picture.
Type in content to fit in each cell. Press the "Enter" key to move to the cell below to continue typing information.
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.
Tips & Warnings
- Consider adding the data and chart files to the flyer workbook by using the "Move or Copy Sheet" function under "Edit" to transfer the desired data worksheets.
- Use the options in the Formatting and Drawing toolbars to embellish blocks of text or create a border.
- The embedded chart is always linked to the source data file, so avoid deleting or moving the file if it's separate from the flyer spreadsheet.