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).
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.
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."
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."
Step 7
Select "Cells" under "Format" and click the "Font" tab.
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.
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.
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."
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.
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.