Tag Archives for " page setup "

[Insanely] Popular Post: Printing Those Monster Excel Sheets

Because I’m always trying to make sure I’m posting tutorials that help as many readers as possible, I regularly check out the statistics on what current posts are getting the most eyeballs (so I can do “more like that“). Sometimes, the stats surprise me.

For instance, who’d have guessed that a post on how to print large Excel spreadsheets would be the #1 most popular post on this blog? Not me.

But it is. And don’t get me wrong: I’m glad it’s helping so many people, especially considering how much work went into it.

In fact, at the time I originally posted it six months ago, I had done a video tutorial to go with the illustrations and text. Unfortunately, I was still scaling the learning curve on my newly-purchased screencasting software, and since I couldn’t figure out how to get rid of the irritating background whine in the the audio portion of the video, I set the video aside and published the post without it.

Now, I’ve gone back and fixed the original video showing the 5 steps to formatting a large Excel spreadsheet for printing, and I’ve added it to the post. So if printing in Excel is a mystery to you, click here to check out the post and the new companion video. (There’s even a downloadable transcript of the video in case the narration’s not 100% clear — I had to talk a little faster than normal in some spots when re-recording the narration!)

27 Printing those monster Excel sheets

My friend Karen has issues.  No, I'm not talking about those kinds of issues.  She's got issues with Microsoft Excel.

Every time her boss gives her one of those monster Microsoft Excel spreadsheets (the kind that span 10 pages across and have 20,000 rows of data) and says, "Print this," she panics.  And then she comes to my desk and begs me to print it for her.

I can't say I blame her.  Unless you've worked with Microsoft Excel a fair bit, the prospect of formatting something that large for printing is pretty daunting.  (I always felt the same way about Lotus 1-2-3 for DOS back in its heyday.  Yes, I am that old.)

I promised her I'd break this process down for her so, in case I'm on vacation one day when she really, really needs something printed now, she'll know how to do it herself.

Keep reading →