How to Print Part of a Worksheet in Excel 2013

If you are editing a spreadsheet in Microsoft Excel 2013 that contains a lot of data, then there are probably times when you need to print something, but you do not need to print all of the data in the spreadsheet. One solution is to delete and hide everything that you do not need, but this can be tedious when you still need that data. So the best solution is to just print part of your worksheet.

This can be accomplished with an option on the Excel 2013 print menu called “print Selection.” Our tutorial below will show you how to use this feature so that you are only printing part of your worksheet in Excel 2013.


Only Print Part of an Excel 2013 Spreadsheet

The steps below will have you select the part of your worksheet that you want to print, then you will print the selected part. This is something that you will need to do each time you only want to print a portion of the spreadsheet, as the default settings will still print the entire sheet.


Step 1: Open the spreadsheet in Excel 2013.


Step 2: Use your mouse to select the portion of the spreadsheet that you want to print.

select the cells to print



Step 3: Click the File tab at the top-left corner of the window.

click the file tab



Step 4: Click Print in the column at the left side of the window.

click the print button



Step 5: Click the Print Active Sheets button, then click the Print Selection option. The Print Preview at the right side of the window should then update to display the part of the sheet that you selected in Step 2.

click the print selection button



Step 6: Click the Print button at the top of the window to print the selected part of the spreadsheet.

click the print button



Is your spreadsheet difficult to read after it is printed out? Print the gridlines and make it easier to read. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.