“Don’t Fear The Spreadsheet” – Print Report: Podcast #1569

“Don’t Fear The Spreadsheet” – Print Report: Podcast #1569

Don’t Fear the Spreadsheet, Episode Number
5: Print to One Page Wide. Hey, welcome back to the Don’t Fear the
Spreadsheet podcast. I’m Bill Jelen, from MrExcel. With today’s question: Tyler Nash. Tyler Nash – MrExcel, this is a problem. I print in my report and the left half of
the report prints on pages one through three. And the right half, on pages four through
six. What gives? Oh, Tyler. I’ve seen this. One of the very first co-workers I ever had,
when that’s what happened to them, they would actually get out scotch tape, and they would
scotch tape the right half to the left half. And I’m like, “Oh, no, that’s just going
to jam that copier”. Alright, so we have an easy way to deal with
this. If we come back here to the Page Layout tab–
Page Layout tab, you see that there are settings here under Scale to Fit. And what you want to do is, you want to open
this up and say that we want to fit to 1 page wide– 1 page wide, and that’s going to force
everything to fit on one page. Now back in Excel 2003, we had this setting
and people would just turn it on like this; Fit to: 1 page wide by 1 page tall. And that would force everything to be really,
really, really small because you had to fit hundreds of rows on one page. So, I like the fact that they’ve made it more
obvious here in Excel 2007 and 2010, how to just change the width to one page and let
the height be as tall as it’s going to be, that– that’s okay. You know, if it fits the three pages that’s
good. Now, I’m going turn this off and just show
you a couple of things; that there are– a way to display page breaks, but they’re not
displayed when you first open the worksheet. So, one way back in Excel 2007, is to use
the little round icon up here, and then, I think, Print and Print Preview. That would get you the old one page print
preview like this, and it’s not the print preview that we want to see; it’s just the
act of going into print preview. Now, if you’re in Excel 2010: File, Print,
will display the print preview over here; and then, as you come out of print preview,
you’ll see that the page breaks are there. I had another co-worker once, the first time
this happened to her, she said, “Well, wait a second, I thought that was just there to
show me the center of the report”. No, that’s not there to show you the center
on the report; that’s there to show you that this stuff’s going to print on one page, and
this stuff’s going to print on another page. So, again, the solution: come back here; Width
1 page; and you are good to go. Well, if you’re new to spreadsheets, check
out this book “Don’t Fear the Spreadsheet”. It is designed for the 40% of people who have
never entered a formula in Excel. This book will make “Excel for Dummies”
look like it was written for rocket scientists.

4 thoughts on ““Don’t Fear The Spreadsheet” – Print Report: Podcast #1569

  • July 3, 2012 at 2:30 pm

    I almost never use the Ribbons – but your Ribbon trick of "Width = 1, Height = Automatic" to get the "1" in the Width textbox and the "blank" in the Width textbox in the Page Setup dialog box is totally awesome!!!

    "Don't Fear The Spreadsheet" makes Spreadsheets For Dummies look like Rocket Science, and also helps people who know something about Excel!

  • July 3, 2012 at 3:22 pm

    I never miss any of your videos! I ALWAYS learn something!

  • July 3, 2012 at 3:23 pm

    I also never miss any of your books! I ALWAYS learn tons!

  • July 4, 2012 at 10:50 am

    Thanks bjele123.


Leave a Reply

Your email address will not be published. Required fields are marked *