Filtering with spaces between rows

Closed

diestra123 Posts 9 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Apr 4, 2013 at 08:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 4, 2013 at 10:46 AM

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.

How to add space between rows in excel
Dead space remake download - Download - Horror
2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
How to add @ in laptop - Guide
How to add songs to sound picker - Guide
How to add photo in word resume - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 4, 2013 at 10:35 AM

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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 4, 2013 at 10:46 AM

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

Subscribe To Our Newsletter!