How to print only specific columns in Excel

This is going to be a short tutorial on printing only specific columns in Excel 2016 & 2013. Earlier we had covered the steps required for printing selected columns and this going to be in addition to that. For this demo, let us take the following sample data.


Now if you want to print only Source, Amount and Collected By columns and leave out Date then you can follow the below mentioned steps.

Step 1: Navigate to Date column, right click and select Hide from the menu list.


Now you should see only the columns that have to be printed.


Step 2: Click the File menu, select Print from the menus.


Step 3: In the Print screen, navigate to Settings and select Print Selection from the dropdown list.


Now the Print Preview section would display the selected columns that will be printed out.

Step 4: Click the Print button to print the required columns.

If you want to take print out the worksheet but with out the hidden column then go for “Only print the active sheets” option.

Please make sure to unhide the column once your printing is complete.

In Category: Excel 2013, Excel 2016

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.