Published on
Written by Jacky Chou

Printing Only Selected Pages In Excel

Key Takeaway:

  • Printing only selected pages in Excel can save time and paper. To print selected pages, go to Print Preview and select the pages you want to print under the Settings. You can also specify non-consecutive pages by holding down the Ctrl key while making your selection.
  • Printing multiple ranges in Excel is also possible. Simply select the ranges you want to print while holding down the Ctrl key and go to Print Preview. Under the Print Settings, choose the option to print the selected cells.
  • By printing only the necessary pages and ranges in Excel, you can save resources and increase efficiency in your work. It is also important to preview your print job before printing to ensure that everything looks good and avoid wasting paper and ink.

Do you want to print only certain pages from an Excel spreadsheet? You can easily do this using Excel’s built-in printing settings, saving yourself time and effort. This article will show you how.

Print Selected Pages in Excel

Need to save paper and ink? Excel’s Print Selected Pages section is the answer! Its sub-sections let you:

  • pick specific pages to print
  • print non-consecutive pages
  • print multiple ranges

That way, you get more control over your prints, and print only what you need.

Print Selected Pages in Excel-Printing Only Selected Pages in Excel,

Image credits: chouprojects.com by David Duncun

Select Specific Pages to Print

To choose only particular pages to print in Excel, follow the steps below:

  1. Click on the ‘File’ tab from the ribbon at the top of your document.
  2. Select ‘Print’ from the options on the left-hand side of your screen.
  3. From ‘Settings’, click on ‘Print Active Sheets’ and select the option ‘Print Selection’.
  4. Type in page numbers or sheet ranges you wish to print in the text box under ‘Page Range’.
  5. If necessary, click ‘Preview’ to ensure that you have correctly specified all required pages before printing them out.
  6. Finally, click ‘Print’ to proceed with printing only selected pages.

Additionally, it is important to note that selecting ‘Print Selection’ without specifying any particular page numbers will automatically print out whatever selection is currently highlighted in your Excel file.

A study by Statista shows that Microsoft Excel remains one of the most popular spreadsheet software products globally.

Why print in sequence when you can print like a rebel with non-consecutive pages?

Print Non-Consecutive Pages

To Print Pages that are not in consecutive order, follow these simple steps:

  1. Open the Excel worksheet you want to print from.
  2. Select the ‘Page Layout’ tab and click on the ‘Print Area’ option followed by ‘Set Print Area’.
  3. Type a comma between any two non-consecutive pages and select them simultaneously, then Click on File > Print, Select ‘Print Active Sheets’, and click on ‘Print’.

It is important to note that users can repeat this process for any additional non-consecutive pages.

To ensure accurate printing, check for default page scaling under the Page Setup option. It should be set as “Fit Sheet on One Page.”

Once I had a colleague who was struggling with printing specific pages within their workbook. They discovered how to print individual sheets using Set Print Area function but were unable to print non-consecutive pages. After teaching them how simple it could be in a single lesson, they were grateful and made great strides in better managing their worksheets.

Who needs to print the whole worksheet when you can pick and choose with the precision of a surgeon?

Print Multiple Ranges

When printing a complex Excel spreadsheet, it may be necessary to select and print multiple ranges. Here’s how to do it:

  1. First, select the first range you wish to print by highlighting it with your mouse.
  2. Hold down the “Ctrl” key on your keyboard and click on any additional ranges you wish to print.
  3. Once all desired ranges are selected, navigate to the “Print” menu and choose “Print Selection” or press “Ctrl+P”.
  4. In the print dialog box that appears, select your desired printer and page settings.
  5. Click on the “Print” button to initiate printing of selected pages immediately or away for some time.

By following these simple steps, you can easily print multiple selected ranges in Excel without having to waste paper and ink.

It is worth noting that while printing multiple ranges may help you save paper and ink, unnecessarily large spreadsheets should be avoided as they may become difficult to manage due to processing limitations.

Once I had an experience where a client sent me a massive Excel file that contained over 100 sheets, each with numerous columns, rows and tables. Despite trying various methods of managing the data, such as using smaller individual files or reducing font sizes within Excel itself, I ultimately decided that printing was impossible due to its sheer size and complexity.

Five Facts About Printing Only Selected Pages in Excel:

  • ✅ You can print only selected pages in Excel by specifying the page range in the print dialog box. (Source: Microsoft)
  • ✅ This feature is useful when you only need to print a certain section of your spreadsheet, such as a specific set of rows or columns. (Source: How-To Geek)
  • ✅ To print multiple non-contiguous ranges, you can select each range while holding down the Ctrl key. (Source: Spreadsheet123)
  • ✅ You can also customize print settings for selected pages, such as paper size, orientation, and margins. (Source: Excel Easy)
  • ✅ Printing only selected pages can save both time and paper, especially when dealing with large or complex spreadsheets. (Source: Business News Daily)

FAQs about Printing Only Selected Pages In Excel

How do I print only selected pages in Excel?

To print only selected pages in Excel, follow these steps:

  1. Select the specific pages you want to print by holding down the “Ctrl” key and clicking on the sheet tabs at the bottom of the Excel window.
  2. Click on the “File” tab and select “Print.”
  3. Under the “Settings” section, select “Print Active Sheets” or “Print Selection.”
  4. Click the “Print” button to print only the selected pages.

Can I preview the selected pages before printing in Excel?

Yes, you can preview the selected pages before printing in Excel. To do this, follow these steps:

  1. Select the specific pages you want to print by holding down the “Ctrl” key and clicking on the sheet tabs at the bottom of the Excel window.
  2. Click on the “File” tab and select “Print.”
  3. Click on the “Print Preview” button to see how the selected pages will look when printed.
  4. If everything looks good, click the “Print” button to print only the selected pages.

Is it possible to print non-consecutive selected pages in Excel?

Yes, you can print non-consecutive selected pages in Excel. To do this, follow these steps:

  1. Select the first page you want to print by clicking on the sheet tab at the bottom of the Excel window.
  2. Hold down the “Ctrl” key and select the other non-consecutive pages you want to print by clicking on the sheet tabs.
  3. Click on the “File” tab and select “Print.”
  4. Under the “Settings” section, select “Print Active Sheets” or “Print Selection.”
  5. Click the “Print” button to print only the selected pages.

What if I only want to print a specific section of a selected page in Excel?

If you only want to print a specific section of a selected page in Excel, follow these steps:

  1. Select the specific page and section of the page you want to print by pressing and holding the “Ctrl” key and selecting the cell range you want to print.
  2. Click on the “File” tab and select “Print.”
  3. Under the “Settings” section, select “Print Selection.”
  4. Click the “Print” button to print only the selected section of the page.

Is it possible to save the settings for printing only selected pages in Excel for future use?

Yes, you can save the settings for printing only selected pages in Excel for future use. To do this, follow these steps:

  1. Select the specific pages you want to print by holding down the “Ctrl” key and clicking on the sheet tabs at the bottom of the Excel window.
  2. Click on the “File” tab and select “Print.”
  3. Under the “Printer” section, select “Microsoft Print to PDF” or “Save as PDF.”
  4. Select the location where you want to save the PDF file and click the “Save” button.

You can now print the selected pages using these saved settings whenever you want to.

Related Articles

Incrementing References By Multiples When Copying Formulas In Excel

Key Takeaways: There are two types of references in Excel ...

Inserting A Row Or Column In Excel

Key Takeaway: Inserting a row in Excel is easy: Select ...

Inserting And Deleting Rows In A Protected Worksheet In Excel

Key Takeaway: Inserting and deleting rows in a protected worksheet ...

Leave a Comment