(partial credit to Helen Bradley projectwoman. More Information about my Problem: There are a delivery notes in my Worksheets: Excel delivery notes Some of them dont have entries in the C-column. So, to resolve this issue, you must make sure each worksheet’s page setup agrees with the others.Īnother resolution if you don’t want to check the individual page setups, or make a change like this with all the tabs highlighted, would be to use the Acrobat Excel add-in and choose the create PDF option. Instead, it insists on having two different PDFs to print to, one for each paper size. For example, Excel can’t print two pages with different paper sizes to the same “piece of paper” (actually a PDF in this case). From the dropdown menu that appears, select ‘ Set Print Area ’. Then, select Print Area from the Page Layout tab, under the ‘ Page Setup ’ group. For this, select the area that you want to print on one page. It turns out this issue is caused by having different Page Setup options on each worksheet. Excel lets you select a portion of your worksheet that you want to solely print on a single page. Click on the option of Print on Both Sides. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. Some PDFs contain multiple worksheets, others only a single one, but all you really wanted was one PDF file with the entire workbook. To print on both sides of the paper, click on File on the Excel Ribbon, click on Print, and click on the down arrow of the default selection of the drop-down list immediately below the Pages: entry to display the selected printer's available options. To set a single print area, select the cells. However, despite selecting to fit the printed area to 1 page wide by 1 page tall, it still prints over several pages. ![]() When the operation finally finishes, Excel has properly printed the workbook to a PDF format, but your worksheets have been split into several different PDF files. Hello, i have written some VBA code to print a selected print area. Everything seems fine, but then Excel asks you to name another PDF, then another, then another, ad infinitum. You press print, Excel asks you to name the PDF, and then it begins to print. If you have ever tried to print a large Excel workbook to a PDF file, you’ve probably run into this issue. Excel Tip – Learn how to print multiple sheets to a single PDF file and not many separate PDF files you have to combine into one.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |