Printing only unhidden rows

[juliettelam]

Hello

I have a worksheet that has rows of information up to row 3000. Sometimes all the rows are shown and sometimes a lot of them are hidden. When I try and print, the rows with info are printed but then the hidden rows are included as just blank pages. Is there a way I can get excel to print only the rows in 1-3000 that are shown and not hidden?

Thank you!

[mlacruz85a]

Hi - go to File tab and then click print on the "settings" select print selection this will only print the cells that you "highlight"

i hope this would help