eliminating blank lines from a page

[drcvlastra]

I have an excel table that has plenty of blank lines included in it. How can I get rid of them?

 

[Peter_SSs]

I have an excel table that has plenty of blank lines included in it. How can I get rid of them?

drcvlastra

Welcome to the Mr Excel board!

Here are a couple of suggestions.

If the table is like the green table (that is, the rows are either completely empty or completely full) then try this:
1. Select A1:C8
2. Data|Filter|AutoFilter
3. Click on any of the little AutoFilter drop-down arrows and choose (Blanks) from near the bottom of the list.
4. Click in the top visible blank row and drag down to the bottom blank row.
5. Edit|Delete Row|OK
6. Data|Filter|AutoFilter to remove the filter mechanism.
You should be left with the non-blank rows.

If the table is like the blue table (that is, rows may be completely empty, completely full or partially full and you want to delete the rows that are completely empty) then try this:
1. Add a 'helper' column. Formula in D12 (copied down) is: =IF(COUNTA(A12:C12)=0,"Del","")
2. Select D11:D17
3. Data|Filter|AutoFilter
4. Filter column D to "Del" from the drop-down.
5. Again, click & Drag to select all visible rows.
6. Edit|Delete Row|OK
7. Data|Filter|AutoFilter to remove the filter mechanism.
You should be left with the required rows.

If neither of these is what you want, post back with more details.

Mr Excel.xls
	A	B	C	D	E
1	Name	Age	Team
2	Sue	15	A
3
4	Don	18	B
5	Ann	16	A
6
7	Ken	15	A
8	Jen	16	A
9
10
11	Name	Age	Team	Delete?
12	Sue	15	A
13				Del
14	Don		B
15	Ann	16	A
16				Del
17	Ken	15	A
18
Blank Lines

1.