Print posters on a regular printer with Excel.

TS-50-RX-TX-board-banner

I recently needed to print out a big schematic diagram of the RX/TX board of a Kenwood TS50 Transceiver. This did not fit on a single piece of paper. Instead of downloading all kinds of crappy tools or uploading the image to some “free” site which is going to use it for whatever they think justifies their definition of “free”, I found out you can do this in Excel. Here’s how:

  1. Make sure the image you want to print out as a poster has a decent resolution
  2. Open Excel (maybe this will work in LibreOffice too, I haven’t tested, let me know)
  3. Drag the image into a new worksheet so that it is top-left of the sheet.
  4. Open the “Print preview” (the little icon in the bottom left of the window)
  5. Resize the image so that it covers more than one page, up to the number of pages you’d like the poster to be. Your screen should now look somewhat like this:
    Screen Shot 2014-05-15 at 21.58.23
  6. Optional: Adjust the page margins.
  7. Print.

After this, you’ll be gluing the pages together, but I think you already figured that out beforehand.

Have fun!

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s