printing certain cells

dehemann

New Member
Joined
Oct 15, 2008
Messages
1
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! :)
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,078
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,786
Messages
5,655,298
Members
418,187
Latest member
polks111

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top