Need to compress some rows...is Auto Filter the best way?
Posted by hansoh on January 10, 2002 10:02 AM
i have a spreadsheet with hundreds of rows. at any given time, only some rows will have data in them.
i don't want to print out the whole spreadsheet if there are no values in some or most of these rows; i only want to print rows with data in there. there will be times, however, when i want to print the whole spreadsheet with ALL the rows.
in the past, i've used the AutoFilter feature. this allows me to compress the spreadsheet to show only the rows that meet a certain criteria (e.g., has data, > $0, value = 1, etc.). once filtered, i can print just the rows i want to. i want to know: is this the best way of doing this? is there a better way? please advise. thanks.