Printing only completed rows in Excel

  MalcSP 11:57 28 Jan 03

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 03

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 03


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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…