Saturday, March 26, 2011

How to Make Posters in Excel


1. Open Excel. Click on the 'File' menu at the top of the screen once it opens. Select the 'Page Setup' command.' Choose the 'Page' tab.
2. Adjust the page scaling to '200%' and click on the radio button next to 'Landscape' for the page orientation. Click on the 'Margins' tab.
3. Click into the text boxes for the top, bottom, left, and right and type '0.5'. Click into the text boxes under 'Header' and 'Footer' and type '0.' This will adjust the margins of each sheet of paper.
4. Click the 'Zoom' tab and set the zoom rate to '40 percent.' Click on the 'OK' button.
5. Click on cell 'A1' and highlight the range 'A1:M42.' This should encompass four full sheets of paper (you can see where the sheets begin and end by the dotted lines on the screen). Click the 'File' menu at the top of the screen, click the 'Print Area' command, and select 'Set Print Area.' Excel will now only print those four pages
6. Click on the 'View' menu and select 'Toolbars'. Click on the 'Drawing' option if it doesn't have a check mark by it to display the 'Drawing' toolbar.
7. Click the Rectangle tool on the 'Drawing' toolbar (it will look like a rectangle). Click on the top left corner of cell 'A1' and drag your mouse to the bottom right corner of cell 'M42.' This will create a blank rectangle across the four pages that will be your poster.
8. Click on the paint can icon on the 'Drawing' toolbar to open the effects menu. This menu will provide you with a list of color options to fill the rectangle with. Click on the 'Fill effects' button to add a picture to your poster.
9. Click on the word art icon on the 'Drawing' toolbar to add text to your poster. Click anywhere on the poster to add a text box. Type what you like in the poster.
10. Click the 'File' menu and select 'Print' when you are ready to print the poster. Click 'OK' to begin printing.
11. Tape the separate sheets of paper which print out together to form the poster. Hang the poster in your office or classroom.

Blogger news