Why does not all posts show in a table?

%3CLINGO-SUB%20id%3D%22lingo-sub-3068111%22%20slang%3D%22en-US%22%3EWhy%20does%20not%20all%20posts%20show%20in%20a%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3068111%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20hope%20someone%20here%20can%20help%20me%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20table%2C%20(this%20is%20just%20a%20sample%2C%20the%20original%20one%20is%20with%20900%20names%2C%20but%20otherwise%20similar).%20In%20the%20column%20%22kursnamn%22%20(column%20D)%20I%20would%20like%20to%20sort%20out%20a%20specific%20type%20of%20couse%20(course%20%3D%20kurs)%2C%20but%20it%20does%20not%20show%20in%20the%20sort%2Fselection%20part%20(I%20don%C2%B4t%20know%20the%20correct%20term%2C%20but%20as%20you%20can%20se%20from%20the%20print%20screens%2C%20there%20are%20mors%20different%20posts%20in%20the%20D-column%20that%20are%20not%20shown%20in%20the%20sort%2Fselection)%3CBR%20%2F%3EWhy%20can%C2%B4t%20I%20see%20them%2C%20and%20how%20can%20I%20do%20to%20sort%20out%20something%20I%20can%C2%B4t%20choose%20from%3F%20(I%20hope%20you%20understand%20my%20question%2C%20I%20find%20it%20a%20bit%20difficult%20to%20explain%20those%20things%20in%20a%20foreign%20language...)%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sk%C3%A4rmbild%202022-01-21%20092240.png%22%20style%3D%22width%3A%20714px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341363iCD6FB69781FAB6F3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sk%C3%A4rmbild%202022-01-21%20092240.png%22%20alt%3D%22Sk%C3%A4rmbild%202022-01-21%20092240.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sk%C3%A4rmbild%202022-01-21%20092753.png%22%20style%3D%22width%3A%20721px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341364i39C5CD6DF36CF281%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sk%C3%A4rmbild%202022-01-21%20092753.png%22%20alt%3D%22Sk%C3%A4rmbild%202022-01-21%20092753.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3068111%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi, hope someone here can help me

I have a table, (this is just a sample, the original one is with 900 names, but otherwise similar). In the column "kursnamn" (column E) I would like to sort out a specific type of couse (course = kurs), but it does not show in the sort/selection part (I don´t know the correct term, but as you can se from the print screens, there are mors different posts in the E-column that are not shown in the sort/selection)
Why can´t I see them, and how can I do to sort out something I can´t choose from? (I hope you understand my question, I find it a bit difficult to explain those things in a foreign language...)Skärmbild 2022-01-21 092240.pngSkärmbild 2022-01-21 092753.png 

6 Replies

@HelenaEA Delete the first blank row and set the filter again.

Thanks, but it doesn´t work anyway. I still dont get more to choose from in the filter

@HelenaEA Don't understand. Row 2 is empty. When you put a filter on row 1 nothing below is picked-up. Remove the filter first. Then delete row 2 and put the filter back on row 1. Then it should work.

Clear the filter first.
Select all edited rows and columns
Filter again
Thank you!!!
It´s extremely strange, because this works in the sample file (that is print screened above) but not on the original one (with 900 names...)
I'll have to investigate it more - but thanks a lot so far!
THANK YOU @Riny_van_Eekelen and @Benny_1857, I gt it now!!! (In the original file as well as the sample one) It was all the empty rows that messed it up - will NEVER use that again!