If you have a requirement where you want to print only certain rows and columns in a spread sheet then you can use print selection or set print area features in Excel 2016 and Excel 2013.
Step 1: Select the Rows or Columns that have to be printed.
Step 2: Click the File menu and select Print from the menu list.
Step 3: In the Print screen, navigate to Settings section.
Step 4: Now select Print selection for the first drop down and Settings section.
The Print Preview screen on the right hand side should immediately reflect the selected rows and columns.
Now use the Print button to take print out of the selected rows and columns.
The second method that we are going to see is by using the Print Area option available as part of Page Layout.
Step 1: Select the rows and columns and navigate to Print Layout menu.
Step 2: Navigate to Page Setup section then click Print Area option and select Set Print Area.
Step 3: Click File menu then Print menu to open the Print Screen.
The Print Preview screen should automatically display only the selected rows and columns without making any changes to Print Settings. Now use the Print button to print the selection in Excel 2013.
Set Print Area can be used when you are frequently printing only those selected rows and columns. But make sure to clear the Print Area once you are done with your Printing.