Author Archive

How to get a “Print PDF” Button in Excel?

One of the features in Excel is the ability to convert Excel files to PDF format. In this article we explain how to create a button in the excel worksheet, which when clicked generates a PDF file of that sheet. Let us take the picture below as example to take a PDF and save it [...]

How to Sort in Excel?

Sorting is used to reorder our data in excel. We can easily reorder the data based on the type of sorting that we choose. We have two methods to sort the data. Method 1: Below are the steps to sort the given data in Excel: Select a single cell anywhere in the range that you [...]

How to Use Conditional Formatting in Excel?

Conditional formatting is used to pick out important data from a huge list of data. Though it is a little difficult to use, knowing the basics can help us in whatever project we are working on. We can use conditional formatting in many ways. Following are the two ways of using conditional formatting. Conditional Formatting [...]

How to Print Only Selected Objects in Excel?

Printing in Excel is a bit different than printing in some other programs, such as a word processor. Printing selected objects is one of the special features in Excel. Worksheet with Objects. Print out with selected objects. The steps below guide us to print only selected objects , from a number of objects (i.e. controls, [...]

How to Take Print Without Objects?

(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) {return;} js = d.createElement(s); js.id = id; js.src = “//connect.facebook.net/en_US/all.js#xfbml=1″; fjs.parentNode.insertBefore(js, fjs); }(document, ‘script’, ‘facebook-jssdk’)); Worksheet with object             Print without object Follow the steps below if you do not want to print objects in a worksheet. Suppose you [...]