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.
There are several ways not to print certain parts of the workbook or worksheet from being printed in Excel 😊.
- Hide rows or columns: Choose the Home-Cells-Format dropdown list to hide the selected rows and columns or just Right Click.
- Hide particular cells: By making the text color the same as the background color.
- Hide cells or ranges: You can also prevent by applying a 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 Dropdown 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.
To Hide cells from Printing use Shape
- 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 a page but at the same time, you want to ignore one column from being printed on the same sheet.
Managing Row and Column before Print
Like here we have five columns and two columns are of the same heading i.e. Unit Price one is cost price and the other is selling Price. Our task is to make sure the actual price column does not show.
- Open the Worksheet, Custom view
- Select tab View
- Select the Range
- Under the 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.
Conceal Charts without deleting
When you have data with the chart, Shapes, etc… and you did not want on Print Page to show any objects along with the table.
Remove Chart from Print
- 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 Sheets from Print
Suppose that you want Print of a workbook, but you find that one sheet is of not required for readers.
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 the workbook but it will take a Print of five sheets as one sheet is invisible.
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 or LOGO on the Excel 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