Our problem started about 3 weeks ago. No updates on Adobe Acrobat DC. Using your suggestions, the only way I was finally able to print a workbook to ONE pdf, was to select each tab, and then SAVE the excel spreadsheet to PDF (rather than PRINT to pdf). Annoying - but it works again. Show
Thank you all, for your clues! Much easier than having multiple pdfs issued for one workbook, and then having to combine them. 🙂 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. If you have ever tried to print a large Excel workbook to a PDF file, you’ve probably run into this issue. You press print, Excel asks you to name the PDF, and then it begins to print. Everything seems fine, but then Excel asks you to name another PDF, then another, then another, ad infinitum. 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. Some PDFs contain multiple worksheets, others only a single one, but all you really wanted was one PDF file with the entire workbook. It turns out this issue is caused by having different Page Setup options on each worksheet. For example, Excel can’t print two pages with different paper sizes to the same “piece of paper” (actually a PDF in this case). Instead, it insists on having two different PDFs to print to, one for each paper size. So, to resolve this issue, you must make sure each worksheet’s page setup agrees with the others. Another 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. See your IT person to get this add-in. Excel gives you a lot of options when you’re trying to print your work. You can choose to print the entire worksheet, a specific area in the worksheet, print multiple sheets, or all sheets at one go. In this tutorial, I will show you how you can print multiple sheets in Excel at one go. These could be some selected sheets or all the sheets in the workbook. And in case you want to print a specific area in multiple/all sheets, you can do that too with a little bit of VBA magic. So let’s get started! This Tutorial Covers:
Print All Sheets at One GoExcel has an inbuilt feature that allows you to specify to print all the sheets at one go. Below are the steps to print all the sheets in the workbook:
The above steps would print all the sheets in the workbook. In case you have a print area set in some of the sheets, then only that print area will be printed. You can also see what will be printed in the Print preview on the right. You can also change page numbers and see what will be printed on each page. Easy enough! Now, what if you only want to print only some specific sheets and not the entire workbook. Read on! Print Multiple Sheets (Selected Ones) at One GoThis is again quite easy to achieve. All you need to do is selected those specific sheets that you want to print and then print it! Below are the steps to print some specific sheets in a workbook in Excel:
When you select multiple sheets, these all act as active sheets while printing. You can also see what will be printed in the Print preview on the right. You can also change page numbers and see what will be printed on each page. Print Multiple Sheets With a Specific Print AreaThis one is a little more complex than the previous two. Suppose you have a workbook with multiple sheets, and you want to print a specific area from each sheet. Maybe there is summary data in each sheet and you only want to print this data and not the entire worksheet. This can be done by setting a print area in all the sheets and then printing these (as shown in the above two methods). Now when it comes to setting the print area:
Once you have set the print area, you can then use any of the above methods to print the sheets. So let me quickly show you how to set the Print area manually and using VBA. Setting the Print Area manuallyBelow are the steps to do this:
That’s it! This would set the print area to the selected cells and when you print this sheet, only the print area will be printed. You need to do this manually for each sheet. So if you want to print specific areas in Sheet1, Sheet4, and Sheet5, you will have to do it for each sheet separately. Setting the Print Area using VBAIn case you have a lot of worksheets, setting the print area manually can be time-consuming. In that case, you can also use VBA to quickly set the print area in one sheet, and then run the code to replicate it to all the other sheets. Note: This method works well when you have the same range of cells that you want to use while setting the Print Area. Below is the VBA macro code that will do this: Sub SetPrintAreas1()
Dim PrntArea As String
Dim ws As Worksheet
PrntArea = ActiveSheet.PageSetup.PrintArea
For Each ws In Worksheets
ws.PageSetup.PrintArea = PrntArea
Next
Set wks = Nothing
End SubThe above code uses the print area from the active sheets, goes to all the sheets in the workbook and sets the same print area in each of these sheets. It uses a loop to go through each worksheet and then set the same area in each worksheet as the print area. In case you want this to be different for each sheet, I believe doing it manually would be faster. Once you have this set, you can now print all the sheets (or some selected sheets), and only the print area will be printed. You can put this VBA macro code in a regular module and run it from there. So these are some scenarios where you can print multiple sheets in Excel in one go. Hope you found this tutorial useful! You may also like the following Excel tutorials:
FREE EXCEL BOOK Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster
Name YES - SEND ME THE EBOOK 1 thought on “How to Print Multiple Sheets (or All Sheets) in Excel in One Go”
|
How do you Print all sheets of Excel at once in PDF?
Pos Terkait
Copyright © 2024 menakung Inc.
