Windows Forum

Ask something
Discussion Locked

Excel 97 Empty Row Challenge

0 helpful
4 replies

by ericl642 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am importing a report from a legacy system into an Excel 97 spreadsheet. When the import is done I have blank or empty rows between each set of data. Is there a way to run a script or macro or something else I can do to delete the empty rows in one easy step?

4 replies

by calves

Not that I know. But you can delete multiple rows or columns by holdind the ctrl key and clicking on eack one of them.

Good luck!

by zaq42

Here's two tricks that may help:

1. In Excel sort the entire recordset by a couple of columns. That should group all of your blank rows together and make them easy to highlight using ctrl or shift to click them. Delete them from there.

2. Openthe worksheet in MS Access and run a Delete Query where columna is blank, column b is blank and column c is blank. That should get it.

Hope these ideas helped!

Andy

by ericl642

Unfortunately, because of the way the information is grouped in the report a sort is not possible so tip one doesn't work. I am not sure how tip 2 would help since my problem is empty rows not columns.

This discussion is closed to new replies.