How to Set "Do Not Print Cell" in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Sometimes not printing cells of a spreadsheet can increase organization and efficiency.

Casual users of Microsoft Excel might be familiar with the basics of spreadsheet design, but the program also offers a few advanced features that are easily learned and can improve efficiency. Whether you want to calculate a cost-benefit analysis or track monthly expenses, there may be information on your spreadsheets that is useful but that you may not want to include on printouts, such as intermediate calculations or extraneous details. Excel gives you the option of designating such areas of your spreadsheet as non-printing areas.

Advertisement

Hiding blocks of cells

Video of the Day

Step 1

Launch Microsoft Excel by pressing your "Start" button and selecting the application from your list of available programs, or click on the icon if you have one saved on your desktop. Open an existing file that contains data rather than a blank worksheet. Create a backup file if necessary to protect yourself from inadvertently deleting data on the spreadsheet.

Advertisement

Video of the Day

Step 2

Highlight a row, column or specific cells in your spreadsheet. To select an entire row or column, point to the row or column headings (numbers for rows and letters for columns) until the regular mouse pointer turns into a right arrow (for row headings) or a down arrow (for column headings). Click the left mouse button to select the row or column. To select a block of cells, go to the first cell you want to highlight, click the left mouse button and drag the cursor until the desired block is selected. Then release the left mouse button.

Advertisement

Step 3

Right-click your selected row, column or block of cells. Select "Hide" from the pop-up menu that appears. If the pop-up menu does not appear, try holding the Ctrl key and right-clicking on the selection. Once you select the "Hide" option, you will see that the selection is no longer visible on screen.

Advertisement

Step 4

Print the worksheet. Select "File" from the menu bar or press Ctrl+P to print your worksheet. Verify that the selected row, column or block of text you designed to be hidden does not appear on the printed worksheet.

Hiding individual and non-adjacent cells

Step 1

Left-click the cell you wish to hide. To select multiple non-adjacent cells, hold down the Ctrl key and left-click the desired cells.

Advertisement

Advertisement

Step 2

Right-click your selection and select "Format" from the pop-up menu. In the "number" category, select "Custom" and manually type in ";;;" without the quotation marks in the "Type" box. Then click "Okay." You will notice that the cell(s) or block of cells are now hidden.

Advertisement

Step 3

Print the worksheet. Select "File" from the menu bar or press Ctrl+P to print your worksheet. Verify that the selected cells you designed to be hidden do not appear on the printed worksheet.

Advertisement

Advertisement

references