Hiding rows and printing only 1 sheet

[thewiseguy]

Hi all,

I have a large worksheet of roughly 500 rows, with totals at the bottom of the worksheet . Often times, I will only use a handful of rows, in which case I would like to hide the remaining 400+ rows. I would like to print only the 1 page INCLUDING the totals row but for some reason I can not print this in less than 2 pages. A page break is always created at the bottom of where I hide my rows, leaving the second page to show only the total amounts. Is there any solution to this?

Many thanks in advance!

 

[Joe4]

Are you having trouble figuring out how to hide the unused rows?
If you hide the rows, is it still printing to multiple sheets?
How many rows of data do you have shown?

It may be helpful to see what your data looks like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[johnnyL]

@thewiseguy Try the 'Page Break Preview' icon at the bottom right of the excel window, see if you can delete the offending page break in there.

 

[jolivanes]

Could you copy the visible cells to a temp sheet with code and then print it?
Although that should not be required if you attack the problem properly.

Worksheets(1).ResetAllPageBreaks