How to print certain cells in Excel

You can watch a video tutorial here.

Excel offers many options when it comes to printing worksheets. As the layout is in the form of a spreadsheet and not a document, it is not immediately apparent how the printout will appear. There may be a situation where you want to print only a section of a worksheet and not the entire worksheet. Since Excel is used for calculations, you may want to print only the result of the calculation and not the data used for the calculations. There are 2 ways of doing this.

Option 1 – Print the selection

 Step 1 – Select the data

  • Select the cells to be printed

Step 2 – Open the Print window

  • Go to File > Print

OR

Press Ctrl+P

Step 3 – Choose the print option

  • Under Settings expand the print menu
  • Choose Print Selection

Step 4 – Check the result

  • Only the selection appears in the Print preview
  • Click Print

Option 2 – Set the print area

Step 1 – Select the data

  • Select the cells to be printed

Step 2 – Set the print area

  • Go to Page Layout > Page Setup
  • Expand the Print Area dropdown
  • Select Set Print Area

Step 3 – Open the Print window

  • Go to File > Print

OR

Press Ctrl+P

Step 4 – Check the result

  • Only the cells set as the print area appear in the Print preview
  • Click Print