CP025: Sexy on spreadsheet, Ugly on Printout

In the 25th session of Chandoo.org podcast, let’s learn how to avoid SSUP syndrome.

What is in this session?

Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the proper print settings.

In this podcast, let’s understand how to create awesome workbooks that look great and print great.

In this podcast, you will learn,

• Frozen & Cars, where my free time goes
• Primer on print settings
  • Width & height of printouts
  • Page breaks
  • Row & column repetitions on every page
  • Size & orientation of paper
• Dealing with unprintables
• Proofing your print settings
• Printing what’s not on screen
• Closing thoughts

Listen to this session

Podcast: Play in new window | Download

Subscribe: RSS

Click here to listen if the player is not showing up.

Links & Resources for printing awesome workbooks:

• Printing worksheets in one page
• How to print Excel cell comments
• Hide formula errors when printing

Advanced Printing scenarios

• Printing multiple pages with different layouts
• Printing Excel reports via Word

Transcript of this session:

Download this podcast transcript [PDF].

How do you stay away from SSUP?

In the podcast, I revealed all my favorite ways format print outs.

What about you? How do you ensure that your spreadsheets look as beautiful on print as they are on screen? What tips you follow?

Please share your thoughts in the comments area.