Printing a small part of an excel file

Apart from other common printing options, one important section is to select what do you want to print. By default, excel assumes that you want to print the complete active sheet. So if your sheet has a lot of data and you currently want to print only a small part of it, Please follow the following steps:

In this example we use sheet 2 of the sample tutorial file. This is a sample school record running in to multiple columns. Let’s say you quickly want to print just the student names & their respective IDs.

To do so, just select the relevant part of the excel sheet:

Click on print(Office Button -> Print)

Under the ‘Print what’ section, choose Selection.

Click on Preview. You will see that this is exactly what you wanted.

You are done, click on Print.

TutorialFiles: