At times you may need to print only a portion of a spreadsheet rather than the entire sheet.  You could hide rows and columns and then unhide the data after printing, however, this method is best to use when data is non-contiguous.  (Refer to article Copying Hidden Cells that includes tips on how to hide data.) The most efficient method, when data is contiguous, is to select/highlight the area of the spreadsheet and print.

Print a selection versus the entire sheet:

ü       Select the portion of the sheet to print. In sample spreadsheet below, A2:C9 have been selected to print.

ü       From the File menu, select Print to open the Print dialog box.

ü    In the Print  what section, select Selection.

ü       To print multiple copies of workbook, select the appropriate number in the Copies section of the dialog box.

ü       To Preview print job: click the Preview button in bottom left hand corner of dialog box (refer to article  on Print Preview for more information) of if in Print Preview, click the Print button.

ü       Click OK button when ready to print.

Using this method, data does not need to be manipulated in any manner before or after printing. This method also ensures the correct data is printed each time a print job is requested.