Printing only completed rows in Excel

  MalcSP 11:57 28 Jan 03
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 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

cherria.

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

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

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

Here's what should be coming to Adobe Project Felix in 2017

Best iMovie for Mac tips 2017 | How to edit video with iMovie: 26 brilliant video editing tricks…