Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Print only rows with data in them

Posted by Clara Denton on December 19, 2000 7:00 AM

I'm working with a spreadsheet that has rows or options for use in preparing estimates. The quantity column triggers the unit price and calculates the extended price. The quote is totaled at the bottom. How can I print just the rows that contain data in the quantity column?

Many thanks!

Re: Print only rows with data in them

Posted by cpod on December 19, 2000 8:23 AM

Select the range of data in quantity column and then:

Edit -> Go To -> Special -> Blanks ->OK

this will select the blank cells in the quantity column. then (with the blanks still selected) go to:
format -> rows -> hide

to hide the rows with no data in quantity

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.