Filtering with spaces between rows

Closed

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

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 at the rate in laptop - Guide
Excel add days to date - Guide
How to add subtitles in kmplayer - Guide

1 response

Réponse 1 / 1

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
4 Apr 2013 à 10:35

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 12 September 2010 Status Contributor Last seen 27 December 2022 555
4 Apr 2013 à 10:46

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!