Those printer(s) (the default one or whichever you assign at the Control Panel level) must have the capability to print on that size paper. The issue is the printer(s) that are attached to the computer running the workbook. “I ran into this before, with a client who only wanted that size paper, which in VBA code is referred to as xlPaper11x17 or xlPaperTabloid. Can you help? I really need to be able to convert these documents on my laptop to Tabloid size layout and Print Preview them as such. Plus, since it was a post from 2004 it may or may not be relevant.
Progress learning sheets for excel and word how to#
I just found this on, but not sure how to do this or what a macro is. That’s because, even if you want to print all the data (the Print Area), you’re probably going to want to print the row and column labels on each page (the Print Titles). But that doesn’t let you off the hook here. Most of the time, you need to print the entire thing. Right off the bat, you’re going to need to decide how much of the spreadsheet to print. Previewing the final result and tweaking where necessary.Controlling Margins, Page Orientation, and Page Size.Setting the Print Area and Print Titles.
Once you’ve acquired some basic skills in Excel, the process for formatting a sheet to print is really pretty straightforward: Taming the large spreadsheet: the process
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. (I always felt the same way about Lotus 1-2-3 for DOS back in its heyday. Unless you’ve worked with Microsoft Excel a fair bit, the prospect of formatting something that large for printing is pretty daunting. And then she comes to my desk and begs me to print it for her. 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. No, I’m not talking about those kinds of issues.
0 kommentar(er)
