How to Do a Pamphlet in Excel

1. Click on the 'File' tab and select 'Print.' Set the layout of the spreadsheet to 'Landscape' and set the margins to '0.25' on all four sides of the page. This will give you the maximum printable area on your pamphlet.
2. Click on the “View” tab and select 'Page Layout' on the left side of the Ribbon. This will change the view of your spreadsheet to one with page borders set. In this view you will also be able to set the width of columns in inches or fractions of an inch which is essential to using Excel as a page layout program.
3. Click on the box at the upper left hand corner of the worksheet area between the two rulers. It has a small triangle pointing down and to the right; this will select all cells in the work sheet.
4. Define your layout grid by clicking on the gray column headers at the top of the worksheet area and set your column widths to a quarter of an inch. Continue the process by clicking on the gray row borders at the left edge of the worksheet area and set your row heights to one fifth of an inch.
5. Switch back to the 'Home' tab. Select cells and use the 'Merge Center' button in the 'Alignment' section of the tab to merge cells to suit your design. For example, if you wanted to center a title on the left side of your brochure you'd select cells A1 through U2 and click 'Merge Center' to make a large box to enter your title.
6. Override the centering of text in a merged group of cells by using the text alignment tools next to the 'Merge Center' button and set the fonts to reflect what you want; larger fonts for titles and smaller fonts for text.