MrExcel.com - Your One Stop for Excel Tips & Solutions

removing 65,000 rows

Posted by James Elliott on January 14, 2002 8:35 AM

Hi there! I have a document that prints all 65,xxx rows. Does anyone know how to remove this so that when I print, I will only print the necessary rows and not waste tons of paper? Please email me and let me know.

Thanks!

James

Posted by George J on January 14, 2002 8:48 AM

Select View, Page break view. Scroll Down to the end of the document, hold down click on (and hold down) the last blue line and drag up to where you want the last piece of printing to be. Then go back to view, Normal

George