Sometimes the user doesn’t want to Print of the whole page from a data, or he/ she doesn’t want to share complete information in worksheet reason might be it contains secret or personal information.
Before this, you must be familiar with what exactly Print in Excel does and learn how it works according to settings.
In this post, you are going to learn how to avoid and remove specific ranges, errors, Worksheets, cells, images, etc. from being printed.
Table of Contents
Download Your Example Excel File
There are several ways not to print certain parts of the workbook or worksheet from being printed in Excel 😊.
- To Hide rows or columns: Choose the Home-Cells-Format dropdown list to hide the selected rows and columns or just Right Click.
- To hide particular cells: By making the text color the same as the background color.
- Hide cells or ranges: You can also prevent by applying custom number format that consists of three semicolons (,).
- Mask an Area: You can mask an area of the worksheet by covering it with a rectangle shape.
- Custom View: This feature enables you to put some information available that is not to be printed.
- Print Area: This option is also used to print only selected columns or areas.
- Hide Charts: To hide charts, images, or objects from data being Printed.
- Settings: It is the easiest way to Print selected ranges or arrays. Select File Tab-Click Print-Under Settings– choose option Print selection from the Drop down menu. It will only print which range you have selected for Print.
Prevent cells from being Printed
Assume that you have a table, and you want Print of that sheet after ignoring a few cells from Printing. Here a user can remove the Tel number of Karen and Michael.
Hide certain cells from Printing
- Open the worksheet to Hide Cells
- Select Insert Tab
- Click Illustration
- Choose Option Shapes
- Click Rectangle Shape
- Fill color as the background color (in this case ‘white’).
Display a few Rows in Page
If you have data with multiple rows and you want a Print of only specific rows or range like here, we want the information of a few team members. For this, we use options Print Area.
Print Certain Rows or Columns
- Open worksheet Rows
- Click on the Page Layout tab
- Select the range B2:F5
- Under Page Setup clicks on the Print area
Use of Custom View in Printing
If you want to print of a page but at the same time you want to ignore one column from being printed in same sheet.
Show page after reducing
Like here we have five columns and two columns are of same heading i.e. Unit Price one is cost price and the other is selling Price. Our task is to give Print after eliminating one column.
- Open the Worksheet, Custom view
- Select tab View
- Select the Range
- Under Views group choose Custom Views
- In Custom View dialogue box click Add
- In Add View box type Name (Actual Unit Price)
- Right-click the selected column and click hide
So, whenever you want Print of Page for Telling the cost price the same steps will be followed only instead of Add option-click Show. It will display the column which is hidden and then take Print of Page. You can also delete the Custom View by clicking the delete option.
To Eliminate Picture
When you have data with the chart, Images, etc… and you did not want on Print Page to show any objects along with the table.
Remove Chart from Page
- Select Sheet to Eliminate Chart
- Right-click the Chart
- Choose the option Format Chart Area
- In the chart, options select Size & Properties icon
- Remove the checkmark from the Print object
Hide Sheet from being Printed
Suppose that you want Print of the whole workbook, but you observe that one sheet is no use of taking Print or you want to avoid a Print of a Particular sheet from the entire Workbook.
But before that change settings as In Print settings by default, it Prints active sheet to Print Entire Workbook.
Change settings In Preview
- Open Excel
- Click Tab File
- Select the Print Option
- In settings select Print Entire Workbook from the drop-down
Eliminate One sheet from Workbook
- Open Sheet, Remove Sheet
- Right-click the sheet Name
- Select option Hide
- The sheet will hide
Even though you have six sheets in workbook but it will take a Print of five sheets as one sheet is Hide from the File.
Remove Watermark on Sheet
Like you have got a file that is inserted with the company logo or text at the background of the sheet. Here our task is to remove that particular image from the sheet.
Delete image on the sheet
- Select sheet Delete image.
- Click Print Titles under Page Setup Group
- Select Header/ Footer option
- Select the Custom Header
- Delete &[picture]
- Click OK
- Don’t forget to check the Preview