Manipulating an Excel Spreadsheet

[Ron Badour]

I created a spreadsheet for a contractor friend which has about 50 rows and
8 columns. He uses the spreadsheet to track jobs that are scheduled or in
progress. The rows are three typed lines in size and are separated by a
single one line row. As a job is completed, the information is taken out of
a row and the row is blank. At some time, another job will then be entered
in the blank row.

When they print out the job sheet, all the blank spaces show up. What they
would like is for the data to "move up" and print with no blank spaces.
They do not want to delete the blank rows since that means that in a couple
of weeks or so, they will then have to recreate rows in which to enter jobs.
Is there anyway of excluding the blank rows from the printed sheet?

Thanks in advance.
--
Regards

Ron Badour
MS MVP
Windows Desktop Experience

 

[Gord Dibben]

Sure.

Select a column then F5>Special>Blanks>OK

Format>Rows>Hide.


Gord Dibben MS Excel MVP

 

[Ron Badour]

Just the ticket--many thanks Gord.

--
Regards

Ron Badour
MS MVP
Windows Desktop Experience