Printing those monster Excel sheets

How easy is that?

Scale a worksheet - Excel

Visit chat. Unless you've worked with Microsoft Excel a fair bit, the prospect of formatting something that large for printing is pretty daunting. How satisfied are you with this response? If you've ever had a worksheet where changing the font size had no effect, this might solve the mystery. It defaults back to Letter size instead of Tabloid size.

News, Tips, and Advice for Technology Professionals - TechRepublic

Click Next , in step 2 of the wizad, check Specify new print settings option, then click Page Setup buton, and in the Page Setup dialog, under Page tab, check Fit to option, and type 1 into next textbox. Jon Crowell Jon Crowell No more guesswork: Programs Tagged With: Actually, we can resize the print area and fit to one page by changing the Scale to Fit settings.

Site Feedback. Print a worksheet. Navigate This Article Taming the large spreadsheet: To continue this discussion, please ask a new question. Does you're Preview change when you edit the setting? Hi, I have just installed excel and I cannot seem to be able to print as in prior versions. Tell us about your experience with our site. Actually the solution is to format the cells based on a condition such as "text in the cell".

How to resize print area and fit to one page in Excel?

Fortunately, you don't have to — and you won't believe how simple the alternative is. How can I convert my worksheets to this size? Sounds likely.

Is there a way to resize the print area and fit all content to one page in Excel? Share this: Step 1: At any point, you can click Print Preview to check your progress.