Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to print areas, selection, and entire workbook in Excel quickly?

This article is going to introduce ways to print areas, print selections, and print entire workbooks in Excel.

Print areas with setting print areas

Print selection or entire workbook

Print multiple selections (print areas) on one page

One click to print the current page

Easily print multiple selections from many sheets on one page in Excel

For example, you want to print several selections from different worksheets. You can print them one by one. But, for saving papers, you may need to print them on one page together. Kutools for Excel's Print Multiple Selections Wizard can help you copy all selections as linked pictures and place them in a new worksheet, and then you can print them on one page with clicking File > Print once. Full Feature Free Trial 60-day!

ad print multiple selections 3



Sometimes you may not want to print the entire worksheet, but only several areas. You can do it with following steps:

1. Select the area that you will print, and click the Page Layout > Print Area > Set Print Area.

doc-print-areas-workbook1               doc-print-areas-workbook2

2. This is optional. If you want to add another print area, you need to select this area, and then click the Page Layout > Print Area > Add to Print Area.

3. Click the File (or Office button) > Print to print these print areas.

Notes:

(1) Each print area will be printed in a separate page.

(2) This method can simultaneously print multiple print areas from the same worksheet only.


Normally Microsoft Excel prints the whole active worksheet. But you may want to print the selection in active worksheet only, or print the entire workbook. This way is about printing selection or entire workbook in Excel.

1. Select the range that you will print later, and click the File (or Office button) > Print.

Note: This step is not necessary if you will print entire workbook.

2. Go to the Settings section, click the Print Active Sheets button, and select the Print Selection or Print Entire Workbook from the drop down list. See screenshot:

doc-print-areas-workbook3

3. Click the Print button to print the selection or entire workbook immediately.

Notes:

(1) For printing selections, this method can only print one selection from active worksheet at a time.

(2) If you are using Excel 2007, you need to click Office button > Print, and then check Entire Workbook option or Selection option in the popping dialog box. See screenshots:

doc-print-areas-workbook4
doc-print-areas-workbook5

Kutools for Excel's Print Multiple Selection Wizard can help you easily print multiple ranges from many worksheets into one page without page breaks.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

1. Click Enterprise > Printing > Print Multiple Selection Wizard. See screenshot:

2. In the Print Multiple Selection Wizard dialog box, click Add button  to add ranges for printing.

Notes:

(1) If you need to print multiple ranges from the same worksheet, you can add them to the Range to print list at a time by holding the Ctrl key and selecting them.

(2) You can click the Remove button to delete selections from the Ranges to print list.

3. Click the Finish button. And then all selections have been copied and pasted as linked pictures into a new worksheet.

4. Click the File (or Office button) > Print to print these selections in one page.

Print Multiple Selections Wizard can help Excel users easily print multiple selections (or print areas) of same worksheet on one page, and print multiple selections from different sheets one one page too.

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!


Kutools for Excel also provides an Print Current Page utility to quickly print the active page that the active cell is located at with only one click in Excel.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

Just click a cell in worksheet, and then click Enterprise > Print Current Page.

And then the current page is printed, and at the same time a dialog box will pop out and tell you which page is printed. See screenshot above:


In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!



Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Mike B · 4 years ago
    Hi, Whenever i try to print an entire workbook it defaults to 2-sided anyway to change this without adjusting every page to one sided? thanks for your help