Printing only completed rows in Excel

  MalcSP 11:57 28 Jan 2003
Locked

I have a formatted 3 page, 104 row spread sheet. the rows will be filled over a six month period and will be printed at the end of each month. Is there a way of automatically printing only up to the last row that has dat entered?

  cherria 12:11 28 Jan 2003

Set up your print range down to row 104.

I assume your columns have headers? I also assume that there is one column that always has an entry in it whenever a row has been completed?

If so, highlight the range down to row 104 including the headers.

Select Data->Filter->Autofilter

Dropdown arrows should appear on the header row for each column.

Click on the dropdown arrow next to the column that always contains a value and select Non Blank from the dropdown list.

Your filtered list should now contain only the rows from 1 to 104 that actually have values in them

File Print..

  MalcSP 12:17 28 Jan 2003

cherria.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?