printing certain cells

[dehemann]

Is there a way to only print certain cells, not using print area. I have a sheet with several columns, and only want the info in the row to print if there is an entry in a certain column. Is there a way to do this? Thanks!

 

[Peter_SSs]

Is there a way to only print certain cells, not using print area. I have a sheet with several columns, and only want the info in the row to print if there is an entry in a certain column. Is there a way to do this? Thanks!

Welcome to the MrExcel board!

I think this could be achieved by a macro (or manually) but would need more details. The process I envisage would involve filtering the column in question then printing the sheet. An alternative might be to copy the relevant rows to a separate sheet and print that sheet.