Thread: Ineffective to filter correctly while click on Format as a Table button in excel

Each time I click on the "Format Table" on the home screen, the formats of my information as a postpone, but when I test out to percolate a column, filter the all table as oozes into my columns. In other words, I determine to filter a column by 2 information that is in row 3, that filter entire other columns of row 3. How I can filter a column minus lamentable the extra columns? Anybody have any suggestion on this?

Here I just wishing to include something in this case. This is precisely how the filter operates, once you filter any column in a table, which is seeable only the information that meets the criteria demonstrated in the first filter. This procedure continues as you make choices in the later columns till you are left with information that contains entire your criteria. If you require selection, based on a one column cannot be part of a table that is more than one column.

I guess we are viewing AutoFilter utilizing a table, hiding rows that do not meet the percolate criteria. I guess you require to make a second table of the first advanced filter does not hide the rows in the first table. You require to utilize advanced filters and tell it to filter to a second. If I did not realize the trouble i have a sample file. You can attach a sample; I will try to defeat your trouble.

I guess the trouble lies down in the definition of a table. It would be a big number of rows and columns minus entirely empty row or column altogether abandon, where the border. When you format information as a table that is treated as a all and we think you require to keep the lines in line with others. To sort a column by itself, easy take the column (click on the column letter over) and type. You will be asked if you require to expand the scope and you say no.

You cannot filter just a solitary column of information from a table. You can, repeat that column (column A) to a different fraction of your sheet (as extensive as it is disoriented by as a minimal one blank column from your table, column AF or larger in your case), or you can repeat it to a unlike sheet. Then you would have a separate table, which you can sieve on its own, independent of any other columns - but I cannot guess why you would require to do this.