Mobile Number Tracker
Trace Mobile Number Earn Money Online

Print Only Specific (Selected) Area, Range in MS Excel

Samyak Lalit | October 14, 2013 (Last update: April 30, 2016)

Samyak Lalit is an Indian author and disability rights activist. He is the principal author and founder of projects like TechWelkin, WeCapable, Viklangta, Kavita Kosh among many others.

MS-Excel is part of the MS-office suite from Microsoft Corporation. It is one of the most popular spreadsheet software in the world. MS Excel worksheet is a huge area full of rows and columns. At times people wish to print only a particular area in a worksheet.

Problem in Printing MS-Excel Worksheet

Because a worksheet is massive –the software makers have built-in a logic that it should print only the area that contains data. Print area is by default set to cover all the cells that have some data. If data there is a lot of data Excel will cover it all in print. If you give print command –it will print all the cells. At times you may not need printout of all this.

How to Set Print Area

MS-Excel provides you with the option of selecting a specific area for printing. This saves you from printing unnecessary pages. To set the print are, do as follows:

  • Select the area that you wish to print
  • Go to Page Layout tab
  • Click on Print Are button
  • Select “Set Print Area”

The selected area will be marked with distinctive border. You can select and add more print areas –and all the selected areas will be printed in one command. But these areas may not necessarily be on one page.

How to Clear Print Area

Following the steps given in the previous section –you will also get option to clear and already set print area. All the print areas will be cleared if you select this option. Also, MS-Excel will automatically calculate and set new print areas as per your printer settings.

We hope that this small tutorial was useful for you. Please feel free to ask should you have any questions related with this topic. We will try our best to assist you. Thank you for using TechWelkin!


Leave a Reply

Your email address will not be published. Required fields are marked *