How to print large excel file on one page

How can I add this? If not this how can I create a custom size page in Excel. They only have a handful of stock sizes and none meet my needs. The page Setup dialog has no options for custom page size either. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites.

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

This data has 10 columns. So, it is tough to fit all these pages into 1 page. Your printed first page will hold only the first 3 columns Product ID, Category, and Sub-Category , the 2 nd page will hold just one column Product Name , and so on. Several types of page sizes are available for printing your Excel worksheet. If your office has an option to print on a larger page, choose a page size like Tabloid, Ledger, or A3.

They are larger pages. Though with a larger page size, we are holding most of the columns in one page, but not all. Still, 4 more columns to be added. It is another option. Excel automatically keeps some places for margins. You can reduce the margins of the page. Personal opinion: In most cases, I will not use any of the above 3 options because this automated selection can destroy your printing.

So, you can also avoid them. I have also changed the wrapping of Shipping Cost cell and made the column width smaller in size. How can I convert my worksheets to this size? I need help ASAP! In addition, I would like to view it in Tabloid, not just print it in that size. Any suggestions? It defaults back to Letter size instead of Tabloid size. I just found this on mrexcel. Plus, since it was a post from it may or may not be relevant. 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.

The issue is the printer s that are attached to the computer running the workbook. 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. Are you sure their printer can accommodate that size? Maybe you are designing the workbook for them but on your computer, your printer is not the type that handles that size paper.

Tom Urtis, May 7, Is there a way to print multiple worksheets to a single pdf where all the worksheets have a different header? I am printing several worksheets as one double sided print workbook job, so because the pages are sometimes in groups of an eneven number of pages I have had to add a trailing blank page every now and then.

My problem is finding a way of supressing the page titles for the blank pages. Can you actually set separate print areas in the same workbook and define which print area has titles and which does not? Thank you so much for posting this, Deborah! Whether you're getting ready for a job interview or just looking to "skill up" to meet daily demands, this Word Skills Checklist can help you find the gaps in your knowledge of basic to intermediate Microsoft Word skills.

Click the button below to download your copy today! Printing those monster Excel sheets. Share 0. Tweet 0. Taming the large spreadsheet: the process. See the following screenshot:. Note : that this method is invalid in Excel Actually, we can resize the print area and fit to one page by changing the Scale to Fit settings.

This method is valid in Microsoft Excel later version. Step 2: Change both of Width and Height to 1 page. If you want to print multiple selection across worksheet into one page, you can apply Kutools for Excel 's Print Multiple Selection Wizard utility to combine multiple selection into one page, then print them in one page.

After free installing Kutools for Excel, please do as below:. In the wizard dialog, add the selections you want to combine into one page by clicking Add button one by one. 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.

If you check Activate the worksheet, but don't print it , it will combine all selections in one new sheet at the front of all sheets.