Filtering with spaces between rows

[Closed]
Report
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hi All,
Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :(

thanks in advance for your help.

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
485
Hi Diestra123,

I don't think Excel has that functionality.
A workaround could be to create double entries, where the text color of the duplicate is turned white. This way it looks like an empty row, but Excel is still able to filter.

Best regards,
Trowa
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
485
Here is a code that might be helpfull in creating the above:

Sub CreateDub()
Dim x As Integer
Dim sCol As String
sCol = "H" 'Adjust Column letter to match your data.
x = 2 'Data starts at row 2, if not change the number.
Do
Range(sCol & x).Copy Range(sCol & x + 1)
Range(sCol & x + 1).Font.ColorIndex = 2
x = x + 2
Loop Until Range(sCol & x).Value = vbNullString
End Sub