• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

2 Ways to Print a Selected Range of Data in Excel

0 Comments

2 Ways to Print a Selected Range of Data in Excel:Usually when printing, you will print the entire worksheet in an Excel file. The extra cells will look messy and unprofessional. So how do you print a small range of data within the entire worksheet? How to print only important data in Excel? In this article, Buffcom.net will introduce you to the ways to print a selected range of data in Excel.

1. Print the Selected Range of Data

First, you need to click and drag the mouse or use the keyboard and navigation buttons to select the entire range of data that you want to print. Then, you select the File tab on the toolbar.
Next, you choose the Print option from the left-hand side menu.

2 Ways to Print a Selected Range of Data in Excel

2 Ways to Print a Selected Range of Data in Excel

Then, under the Settings section, you change the default mode from “Print Active Sheets” to “Print Selection“. That’s all you need to do to select only the selected range of data. At this point, the Print Preview section will display the selected range of data for you to preview before printing. Now, you need to adjust the margins to make it look good, choose the number of copies to print, and select the printer. Finally, click Print to print the data.

2 Ways to Print a Selected Range of Data in Excel

2 Ways to Print a Selected Range of Data in Excel

2. Print the Predefined Range of Data

With the above method, each time you print, you have to select the range of data. However, if you want to create a fixed print range, you need to select the range of data to be created first. Then, you select the Page Layout tab on the toolbar. Next, you choose the Print Area => Set Print Area option.

2 Ways to Print a Selected Range of Data in Excel

2 Ways to Print a Selected Range of Data in Excel

That’s all the selected data has been created as a fixed print range. At this point, the Name Box will display “Print_Area“.

2 Ways to Print a Selected Range of Data in Excel

2 Ways to Print a Selected Range of Data in Excel

Next, you select the File tab on the toolbar and then select the Print option. Or you can also use the shortcut key combination Ctrl + P to open the printing interface. Here, the predefined print range will appear for you to preview the data. Now, you need to adjust the margins to make it look good, choose the number of copies to print, and select the printer. Finally, click Print to print the data.

2 Ways to Print a Selected Range of Data in Excel

2 Ways to Print a Selected Range of Data in Excel

Thus, the above article has introduced you to the ways to print a selected range of data in Excel. Hopefully, the article will be helpful to you in your work. Good luck!

Rate this post
28
272 Views
2 Ways to Copy Values in ExcelPrev2 Ways to Copy Values in ExcelMarch 15, 2023
How to show/hide Sheet Tabs in ExcelMarch 16, 2023How to show/hide Sheet Tabs in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Microsoft Visio Professional 2021 Key 1PC Microsoft Visio Professional 2021 Key 1PC $13.00
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.