Forum Discussion
Excel Sorting/filtering
Hello,
Below you can see an example of some shipments to warehouses. I want to sort this by land for example. When you filter this, you will not get a blank row. I really want a blank row between different data as you can see below. On the picture below I insert the blanc row by myself, but i it possible to do this atomatically when I push the filter?
Thanks in advance.
To achieve this, you may follow these steps...
1. Select all the cells in the Land column including Blanks in between.
2. Press Ctrl+G to open the Go To Window and click on Special and choose the radio button for Blanks
and click OK.
3. After the above steps, all the blank cells will be selected. Now type = and press up arrow once. This
will insert the formula in the first blank cell and press Ctrl+Enter. The formula will be entered in all
the blank cells and return the Land from the above cell.
4. While all the cells are still selected, press Ctrl+1 to open the Format Cell window and go to Number
Tab.
5. Now go to Custom and replace General in the TextBox under the Type with three semi-colons ;;; and
click on OK to finish.
After performing the above steps, all the blank cells will be populated with Land values but will not be visible and then you may sort the data as per your need.
Please find the attached to see the end result after performing all the steps.
3 Replies
To achieve this, you may follow these steps...
1. Select all the cells in the Land column including Blanks in between.
2. Press Ctrl+G to open the Go To Window and click on Special and choose the radio button for Blanks
and click OK.
3. After the above steps, all the blank cells will be selected. Now type = and press up arrow once. This
will insert the formula in the first blank cell and press Ctrl+Enter. The formula will be entered in all
the blank cells and return the Land from the above cell.
4. While all the cells are still selected, press Ctrl+1 to open the Format Cell window and go to Number
Tab.
5. Now go to Custom and replace General in the TextBox under the Type with three semi-colons ;;; and
click on OK to finish.
After performing the above steps, all the blank cells will be populated with Land values but will not be visible and then you may sort the data as per your need.
Please find the attached to see the end result after performing all the steps.
- Thank you a lot for this explanation. I appreciate your effort!
I need it for my graduation assignment. It helps a lot.You're welcome TobiVanThielTransport!
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.
