To do that totally automatically would require some VBA (in the BeforePrint
event in the ThisWorkbook module). Without code and not quite automatic try
this

Ensure there's at least one row above your table
Say your Table is in C2:J20
In a helper column either to left or right of your table, let's say in Col-B
B1: "nonEmpty" or whatever you want but not empty
B2: =COUNTIF(C2:J2,"")
- copy down to at least to the bottom of your table or beyond
- each cell should return the number of non empty cells
select B1
Data, Filter, AutoFilter

When you want to print, select the filter arrow in B1 and "0"
Blank rows should hide

When done reset the filter to All or clear it completely from the same Data
menu

Previously you should have set your print-area to exclude the helper column
and top filter row, probably just your table in C2:J20

Regards,
Peter T


"TM" wrote in message
...
How can I auto hide empty rows in printing a table in excel?