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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…