Keeping blank rows when sorting

I have a spreadsheet that I want to keep the blank rows that seperate the data for asthetic reasons. Can I sort just the rows with data in them and still keep the blank rows where they are?

Thanks for your assistance

Originally Posted by EdMac

I presume you have groups of data separated by blanks and you want to sort within the sets.

I think you can only do this by sorting each set of rows individually - Excel would not know where to put blanks otherwise

I have an idea, but don't know much about changing the filter settings. So perhaps you know.

Is it possible to have it filter for things in common?

For example, you have 2 variations of inputs, and create a 3rd.
a,
b,
a, b

The idea being that you would make the "blank" row a, b and change the font color to make it appear hidden.

Then when you select either a, or b, it could also recognize either value in the "blank" and leave that in the chart? The challenge would be if there were a lot of variations, then that blank cell would need to contain all of them.

Here is a model of what I mean for the filter allowing the "blank" rows. Maybe it's better to refer to them as the universal value row?

This thread wasn't started discussing the purpose, it was started asking how to do it. But to give an example where it could help: we have a type of catalog that has say 20 different categories with 250 different items. It was setup to have the blank rows in between, which makes it easier to visually scroll through. In that case, it'd be nice to filter and keep the natural segregation. The alternating row colors option wouldn't work well as filtering could combine similar colors afterward.

The one solution I can think of is having 1 column for each possible autofilter selection (say type a and b would use 2 columns). Then you would hide an A in the "blank" row in the A filter column, and a B in the B filter column. That way when you select A, the "blank" row automatically matches, and stays. This method works if you don't have a lot of items to categorize. But if you have 10 or so categories, it starts taking a lot of columns to do this. I really wouldn't consider this a good solution either, it's more of a band aid fix.

Here is the worksheet I need to sort and keep the blank rows where they are. Any suggestions on how to do this better?
Keep i nmind this is to display golf scores as they are coming in so it will be updated throughout the day.

the simplest way is to reference cells on another sheet
do your sorting on the other sheet.

see sheet 2

I had an idea and I think I have the code that works. I created a series number column and used Ctrl down to find where the data ranges and blank lines were, then numbered each set as a series. It let me sort within the data sets and keep the blank lines exactly where they were.

Please Login or Register  to view this content.

Hello everyone,

I wanted to ask something as well i am trying to create a macro that sorts rows based on value of 2 columns, but every time that value changes in either of them to leave an empty row between them.
Is that possible? In simple words i want to separate my rows and sorting them out alphabetically.

Kind regards, Andriano